Setting Your Default Directory

by Allen Wyatt
(last updated March 1, 2014)

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. (See Figure 1.)
  3. Figure 1. The General tab of the Options dialog box.

  4. Change the Default File Location box to reflect the path of the directory you want to use as the default for your Excel files.
  5. Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2632) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Making Spell Check Ignore Characters

The rules of professional editing often require that editorial changes in a quote be noted with brackets. These brackets, ...

Discover More

QuickWords in Word

WordPerfect users coming to Word may miss a feature called QuickWords. This tip examines some ways you can get around the ...

Discover More

Calculating a Future Date

Need to figure out a date a certain number of days, weeks, months, or years in the future? It's easy to do using the DateAdd ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Starting in Safe Mode

By using a command-line switch, Excel can be started in safe mode. This means that the program is loaded with bare-bones ...

Discover More

Fill Color Doesn't Display

If you apply a fill color to a range of cells and notice that the color doesn't show up on the screen, it could be because of ...

Discover More

Understanding Lists

What is a list of data, and how do you create one? Here are some guidelines you may find helpful.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share