Skip to main content

File Management Tricks

File Management Tricks-
Rename a file quickly Right-clicking and selecting rename is not very efficient. Instead press F2 while a file is selected to change its name. To alter the name of another file, type Tab without deselecting the current file. On Macs, hitting Enter will rename (which may sound counter-intuitive to Windows users) while Cmd + O is used to open.
Cloud backup important files If you're working on a critical project, make sure you aren't backing up locally only. Services like DropboxGoogle Drive, or any of the other popular cloud storage solutions will do the legwork for you in the background. Of course, you can also throw the files on a thumb drive or external HDD to be extra safe, but backing up to the cloud can be done seamlessly.
Rename files sequentially in Windows or Mac You actually don't need to download any programs to perform a batch file rename. Instead, you can select all the files you want to change, right-click the first one in the list, select rename (or use F2), and type in the name. This will automatically change all the other files with the same root name with a suffix: (1), (2), and so on.
On Mac, you can do something similar. Select the files, then right click and an option to rename the whole batch as a series will show up.
Select multiple files using the keyboard To select a bunch of files using your keyboard, you can press Shift + Down Arrow to select a single file or Shift + Page Down to select a large group of files at one time. Ctrl + A will select everything.
Right click drag files and folders in Windows And you'll be presented with a context menu containing options to move, copy, zip or create a shortcut.

Comments

Interactive Blogposts

Top 100 Useful Excel Macro [VBA] Codes Examples

Yogendra98.blogpost.com You can automate small as well as heavy tasks with VBA codes. And do you know with the help of macros, you can break all the limitations of Excel which you think Excel has? So today, I have listed some of the useful codes e xamples to help you become more productive in your day to day work. You can use these codes even if you haven't used VBA before that. All you have to do just paste these codes in your VBA editor. These codes will exactly do the same thing which headings are telling you. For your convenience, please follow these steps to add these codes to your workbook. Before you use these codes, make sure you have your developer tab on your Excel ribbon to access VB editor. If you don't have please use these simple steps to  activate developer tab . Once you activate developer tab, you can use below steps to paste a VBA code into VB editor. Don't Forget:   Make sure to  download thi...

OFFSET combined with SUM or AVERAGE_#Yogendra

           OFFSET combined with SUM or AVERAGE Formula: =SUM(B4:OFFSET(B4,0,E2-1)) The OFFSET function on its own is not particularly advanced, but when we combine it with other functions like SUM or AVERAGE we can create a pretty sophisticated formula.  Suppose you want to create a dynamic function that can sum a variable number of cells.  With the regular SUM formula, you are limited to a static calculation, but by adding OFFSET you can have the cell reference move around. How it works:  To make this formula work, we substitute ending reference cell of the SUM function with the OFFSET function.  This makes the formula dynamic and the cell referenced as E2 is where you can tell Excel how many consecutive cells you want to add up. Now we’ve got some advanced Excel formulas! Below is a screenshot of this slightly more sophisticated formula in action. Add caption As you see, the SUM formula starts...

29 Incredibly Useful Websites You Wish You Knew Earlier@yogendra

Share Pin it Tweet Share Email There are so many wonderful websites around, and it is difficult to know each and every one of them. The below list provides some of those websites that I find particularly helpful, even though they are not as famous or as prevalent as some of the big names out there. 1.  BugMeNot Are you bugged constantly to sign up for websites, even though you do not wish to share your email? If yes, then BugMeNot is for you. Instead of creating new logins, BugMeNot has shared logins across thousands of websites which can be used. . 2.  Get Notify This nifty little website tracks whether the emails sent by you were opened and read by the receiver. Moreover, it also provides the recipient’s IP Address, location, browser details, and more. 3.  Zero Dollar Movies If you are on a constant lookout of free full length movies, then Zero Dollar movies provides a collection of over 15,000 movies in multipl...