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:
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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6136) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Sorting Files.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
When importing information from a CSV file, you may get unintended results from time to time. Here's how to force Excel ...
Discover MoreExcel tries to make sense out of any data that you import from a non-Excel file. Sometimes this can have unwanted ...
Discover MoreIf you open a workbook and notice that Excel displays two windows for it, this has to do with how the workbook was saved. ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-03-08 12:24:48
Doug James
T00613 is worthless for my Xl 2010. No place I can find "Arrange Icons".
This is the first example I have seen after using your ExcelTips for years.
2015-04-23 13:01:32
Rich Greves
I have the 'Arrange by' list in the file open box, but all of the entries are grayed out. I've also tried the right-click method, but to no avail. I can sort the lists, however, by clicking on the title bar (Name/Date Modified/Type/Size)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments