Buzz
Modifying the default directory for saving Excel files on your computer facilitates easy organization and manipulation of Excel files within your designated folder. To carry out this task, you'll need to use Microsoft Office version 2007 or later.
Guide to Customizing Default Directory for Saving Excel Files
For Excel 2007
Step 1: Prepare a dedicated storage folder and then select Office button -->Excel Options.
Step 2: A dialog box will appear, choose the Save tab. In the Default file location section, specify the path for the default storage folder when you select Save. Press OK. For example, if you create a folder named 'Mytour' on drive E, input 'E:\Mytour' into the default file location field.
That's it, from now on, any Excel files you create will be saved here by default.
For Excel 2010
Step 1: Create a storage folder beforehand, then select File -->Options
Step 2: In the dialog box, choose the Save tab. In the Default file location section, specify the path for the default storage folder when you select Save, then press OK.
When you choose Save, the file will be saved in the folder you specified, not in Documents anymore.
Here, we have just performed the steps together to change the default folder for saving Excel files on your computer. From now on, any Excel files you create will be saved by default to the path you specified, making it easy to work with them. Additionally, you can also explore Changing default interface colors, Changing default gridline colors in Excel, ....
