tfdlogo_smallweb.jpg
Change the Default File Location in Excel PDF Print E-mail
When you choose to open or save a file in Excel by default you are directed to the My Documents folder. If you regularly save your files into another drive or folder you can boost your productivity by changing the default file location in the Excel program options.

Change Excel Default File Location

Excel 2003

  1. Open My Computer and navigate to the folder where you store your files and click on the folder to select it.
  2. Click into the My Computer Address Bar to highlight the folder address.

    My Computer Address Bar
  3. Press CTRL + C to copy the address.
  4. Close My Computer and switch back to Excel.
  5. Click on the Tools menu and choose Options.
  6. Click on the General Tab.
  7. Highlight the default path in the “Default File Location” box and press CTRL + V to paste the new path.

    Excel Default File Location
  8. Click OK.
  9. The next time that you choose File, Open or File, Save As… Excel will point to the selected drive or folder.

Excel 2007

  1. Open My Computer and navigate to the folder where you store your files and click on the folder to select it.
  2. Click into the My Computer Address Bar to highlight the folder address.

    My Computer Address Bar
  3. Press CTRL + C to copy the address.
  4. Close My Computer and switch back to Excel.
  5. Click on the Office Button and click the Excel Options Button.

    Excel 2007 Options
  6. Click on the Save Tab on the left of the Excel Options dialog box.

    Excel 2007 Save Options
  7. Highlight the default path in the “Default File Location” box and press CTRL + V to paste the new path.

    Excel Default File Location
  8. Click OK.
  9. The next time that you open or save a file Excel will point to the selected drive or folder.

 
 
< Prev   Next >
[ Back ]