Tuesday Tip: file management from the "Save As" dialog box

You might be aware that it is possible to add a new folder from your typical "File, Save As" dialog box. But did you know that basic file management is also possible?

For example, suppose you've modified an existing spreadsheet and, when it comes time to save it, would like to keep its original filename, but not overwrite the version you modified. (see figure at left)

In this case, you're ready to save "ARSTOCK7.xls" except for the fact that ARSTOCK7.xls already exists.

Using the Save As dialog box as a mini-Windows Explorer, though, you can modify the filename of the original ARSTOCK7.xls file. Simply move your cursor over the filename in the list, click once, and you enter "edit" mode. (see the next figure) After you've renamed your original file you can then save you modified file (e.g., ARSTOCK7.xls).

The Save As dialog box also allows you to move files into displayed folders, such as the "archived" folder shown.