Latest posts by techwriter (see all)
- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 2016
- How to View a List of All Open MS Word Documents through VBA Macro - August 31, 2016
© 2011 Ugur Akinci
When you try to save a MS Excel 2007 or 2010 file, the default save location is the My Documents main folder. If you do not change it, Excel will save all your spreadsheets into that big bath-tub of a folder, together with all your hundreds of other files created by all kinds of different applications. Soon you’ll have a mess in your hands.
To keep things under control, I advise you create a special default folder for your Excel files on your C drive. Let’s call it “Excel_Files” for simplicity’s sake.
Follow these steps to set “Excel_Files” as your standard folder/directory to save the Excel files by default:
Click the Excel Button (upper left) and then click the Excel Options button to display the Excel Options screen.
Select SAVE from the left navigation sidebar to display the Save options.
Select and delete the contents of the following fields:
- AutoRecover File Location
- Default File Location
Instead, type in “C:\Excel_File” or the name of any other file that you’ve created for this purpose:
Click OK to save. From now on all your Excel files will automatically be saved in this special folder unless you change the folder in the Save As dialog box.
ALSO RECOMMENDED: Change the default save format from “.xlsx” to “.xls” by selecting the “Excel 97-2003 Workbook (*.xls)” option from the “Save files in this format:” drop-down list.
This would maximize the number of people who can open the Excel files you send to them since some people may not have the most updated Excel version that’s needed to open the “.xlsx” files.
Don’t forget to click OK and save the change.