Setting Your Default Directory

Normally, Excel starts looking for spreadsheets in the directory in which you started the program. Typically this is your directory. If you want to change the default directory path, you can do so in the following manner:

1. Choose Options from the Tools menu. You will see the Options dialog box.
2. Make sure the General tab is selected. (Click here to see a related figure.)
3. Change the Default File Location box to reflect the path of the directory you want to use as the default for your Excel files.
4. Click on OK.