Excel - Change the Default File Location

When you try to open an Excel workbook, Microsoft's default is to look in your c:\documents subfolder.

Here's a quick trick I use to change the default file location. The seconds you save will add up to hours over time.

• Click on the Tools menu.
• Click on Options.
• Select the General Tab.
• Under Default File Location, type in your new location (ex., c:\excel). By the way, you can also change the number of sheets in a new workbook (Excel's default is 3).

For additional information, see Learn Excel Formulas from A to Z - Atlanta Excel Training Class.