By Allen Wyatt for Excel.Tips.Net
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.If you are using Excel 2007, click the Office button and then click Open. If you are using Excel 2010, click the File tab of the ribbon and then click Open. In either case, 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.