Add favorites to "Save" window

[Anne]

How do I add the favorites folder to a "Save" or "Save As" window, so I can
just open favorites, click on the folder and save an excel file directly to
the correct folder without having to go through drive, directory,
subdirectory, folder, subfolder to save it?

 

[Gord Dibben]

Anne

What version of Excel are you running?

2002(XP) and newer should already have "Favorites" on the "My Places" bar in
the file>save as and file>open dialog.

If not there, see this KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;282087

You can stick any folder you want onto the "My Places" bar.

Also the default folder can be typed into the dialog box at
Tools>Options>General>Default file location.

"Save" will use that folder.

Gord Dibben Excel MVP