Defining Where Word, Excel, PowerPoint Look for Files

Use in these programs:   Word, Excel, PowerPoint

It's good to know where your files are. Knowing about Windows Explorer, you can create folders and even folders within folders for storing files. If, for instance, you frequently create Word documents that are letters, you could have a Letters folder, and perhaps subfolders within called Students, Parents, Faculty, etc. Then, when saving, you would save to the appropriate Letters subfolder. (For more info on organizing files using Windows Explorer, begin with this tip.)

Following the above example, life would be easier if, when opening saved documents, Word "knew" to focus on the Letters folder. Well, life CAN be easier! By changing one of Word's options, you can have Word focus immediately on a frequently-accessed folder upon going to the command File, Open.

Where to go?

Go to Tools, Options:

Fig. 1

And then to the File Locations tab:

Fig. 2

How can this help?

The File Locations has many options to change. The one you'll benefit from the most is the first: Documents. This one tells Word where to "look" when File, Open command is sent. In above Fig. 2, Word is set to look in a folder called Letters. And with that setting, when going to File, Open, the Open box shows the impact this has on Word:

Fig. 3

Changing the Documents location setting

If you create a folder called Train Hanover and realize that for quite a while most of your work in Word will be stored there, then to make life easier, you'd want to redefine where Word looks when opening files. To Tools, Options to the File Locations tab. To cause Word to look at a different folder than the Letters folder, select the Documents line then click the Modify button on the low right:

Starting at the C: drive. . .

you find the desired folder you want Word to look in:

and double click to set it as the Look in: location.

Train Hanover is the folder where Word will now look upon using the File, Open command:

Does this work in Excel?

To set the File, Open location in Excel, go to Tools, Options (as in Word), but then to the General tab. The dialog box looks a little differently and is changed a little differently; you must know what folder/subfolder to enter into the Default file location:.

In PowerPoint?

Again, Tools, Options is the place to go. But to the Advanced panel, typing in the Default file location where most of your PowerPoint files are saved:

Questions? Call Peggy at 6836 or email.
Workshop calendar is here.
To subscribe to Computer-Tips mail list, send an email to byers@hanover.edu putting this in the body: join computer-tips.
To unsubscribe, send an email to byers@hanover.edu putting this in the body: leave computer-tips.

To Hanover's Intranet
------- To Hanover's Homepage
Sponsored by Academic Computing, Hanover College