Microsoft Office Tutorials and References
In Depth Information
Making Sure That the Data Is Safe and Sound
When you finish making changes in the Save As dialog box, click the Save
button or press Enter to have Excel 2013 save your work. When Excel saves
your workbook file, the program saves all the information in every worksheet
in your workbook (including the last position of the cell cursor) in the
designated folder and drive.
You don’t have to fool with the Save As dialog box again unless you want to
rename the workbook or save a copy of it in a different folder. If you want to
do these things, you must choose File ➪ Save As or press Alt+FA to choose the
Save As command rather than clicking the Save button on the Quick Access
toolbar or pressing Ctrl+S.
Changing the default file location
Whenever you open the Save As dialog box to save a new workbook file,
Excel 2013 automatically selects the folder listed in the Default File Location
text box on the Save tab of the Excel Options dialog box (File ➪ Options ➪ Save
When you first start using Excel, the default folder is the Documents folder
under your user name on your hard drive. For example, the directory path of
the default folder where Excel 2013 automatically saves new workbook files
on my computer is
The very generic Documents folder may not be the place on your hard drive
where you want all the new workbooks you create automatically saved. To
change the default file location to another folder on your computer, follow
1. Choose File ➪ Options ➪ Save or press Alt+FTS to open the Save tab of
the Excel Options dialog box.
The Default File Location text box displays the directory path to the
current default folder.
2. Click in the Default File Location text box.
To edit part of the path (such as the Documents folder name after your
username), insert the mouse pointer at that place in the path to set the
3. Edit the existing path or replace it with the path to another folder in
which you want all future workbooks to save to automatically.
4. Click OK to close the Excel Options dialog box.