File management on the fly


The File Open and Save dialog boxes in Office have many not-obvious features which let you do a lot of file management and housekeeping on the spot.

Continuing our series on the File Open and Save dialog boxes in Office (part 1 and part 2).

The File Open and Save dialog boxes in Office have many not-obvious features which let you do a lot of file management and housekeeping on the spot.

This isn’t feature-itis, it can be handy. You try to save a document and realize you need a new sub-folder. Or open a document and want to move it to a different folder. Or just realize that your documents are in a mess and you decide to do some impromptu reorganization.


RESIZE THE DIALOG

The File Open dialog has traditionally been small, too small for anything beyond finding and opening. But the last few versions of Office changed to a resizable dialog box.

Just look in the bottom right corner of the dialog and you’ll see some small diagonal lines – click and drag on them to resize the window.


RIGHT-MOUSE CLICK IS THE KEY

The key to file management in the dialog box is the right mouse menu. Right-click on a file and you’ll find many options (they vary according to your setup and the file you’ve selected). For our purposes today we’re interested in some old faithfuls:



  • Cut

  • Copy

  • Paste

  • Delete

  • Rename

The first three work much the same way as they do when you’re moving text around.

Cut removes the file to the clipboard and lets you choose Paste to move the file to a new folder.

Copy makes a copy of the selection and lets you choose Paste to put a copy of the file in another folder.

Paste only shows up when there’s something in the clipboard (in this case from Cut or Copy) and will save the file/s to the folder new displayed.

Delete doesn’t really delete as I expect most of you know. Instead the file is moved to the Recycle Bin for later deletion.

Rename will change the file name display into an editable field so you can type in a change of name (or fix a badly named file).

$$PAGE$$

COPYING A FILE INTO THE SAME FOLDER

You can make a copy of an existing document while in the File | Open dialog.

Right-click on the file name and choose Copy

Then right click again and choose ‘Paste’.

A clone of the original file will be created called ‘Copy of …’

You’ll almost certainly want to rename the newly created file – just right-click again and choose Rename.

Then double-click on the file to open it in Office.


USING EXPLORER

Naturally you can use Windows Explorer to manage your files and even open them in Office programs but you can also drag files between the File dialog boxes and Explorer windows.

Just click on a file name in a File dialog and drag it to an open Explorer window or vice-versa.

In other words – treat the File dialog like another Explorer window and move files to and from it as you would any other folder.

$$PAGE$$

ARCHIVE OPTIONS

If you have file compression software like WinZIP or RAR loaded then you have even more file management options available on the right-click menu in File Open.

Depending on the software you can compress files into a smaller form or extract a file from existing archives.


REFRESH

If you make file changes in the File Open dialog or an Explorer window open to the same folder, the exact display of files might not be correct.

To show recent changes just press the F5 (Refresh) button to force Windows / Office to redisplay the contents of the folder.


SORT THE COLUMNS

The Details folder view is my favorite not just because it shows many files in the available screen space but also you can find what you want a bit faster by sorting the columns.

Like most Windows lists you can sort the list by clicking on the heading column – click once to sort in that order, click a second time in the same heading to reverse the order.

Use this to find the most recent or oldest documents in that folder. Click on the Date Modified column to sort by date and the most recent files will float to the top (click again if they don’t to reverse the date sort).

Naturally you can use the other sorting columns to arrange the files by name or file type.

$$PAGE$$

SHORTCUT KEYS

The File Open dialog doesn’t have the same menus as normal Explorer windows, except for the right-mouse click menu, and so remembering some shortcut keys can speed your work. Even better, these same shortcuts work in other situations.

Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V

These also work for text in Word and almost any other Windows program because they are standard shortcuts that pre-date Windows.

F2 Rename

 


Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.