Sorting Files when Opening Workbooks

When you choose to open a workbook in Excel, you are presented with a fairly standard Open dialog box. This dialog box is the same as those used in many other Windows programs. One of the neat features you can do, however, is to control how the files are sorted in the dialog box. To accomplish this, follow these steps:

1. Click on the Open tool visible when you click the Office button. Excel displays the Open dialog box.
2. Click on the down-arrow at the right side of the View tool on the toolbar in the Open dialog box. Excel displays a drop-down menu.
3. Choose Arrange Icons from the drop-down menu. Excel displays some choices on how the files in the Open dialog box can be sorted.
4. Select the order in which you want the files sorted. The files are reordered right away.

On some combinations of Excel and Windows, these steps won't work because there is no Arrange Icons option on the drop-down menu. In this case, right-click in the file area of the Open dialog box. On the resulting Context menu you should see the Arrange Icons option or a Sort By option.

When you are done using the Open dialog box, Excel remembers the setting you specified for arranging files. This means that the next time you display the Open dialog box, the files displayed will still be sorted according to your specifications.