How to Show Recently Modified Files in Excel Workbook Gallery
Question details
The user wants to view and sort their files by the last modified date rather than the last opened date within the Excel Workbook Gallery.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Locating a recently updated spreadsheet from the Excel startup screen or file gallery.
- Observed behavior
- The Excel Workbook Gallery restricts sorting to the 'last opened' date and lacks a configuration option to set 'last modified' as the primary sort order.
Keep in mind that the Excel Workbook Gallery does not natively support sorting by the modified date. The methods below utilize alternative file browsing features built into Excel and your system to achieve the desired sorting result.
Use the Browse Dialog to Sort by Modified Date
Bypass the Workbook Gallery and use Excel's built-in file browser to view and sort your documents by their modification date.
Since the Workbook Gallery is hardcoded to sort by the date files were last opened, the most reliable alternative is to use the standard Open dialog. This allows you to leverage detailed file properties.
Launch Excel and click on the 'File' menu located in the top ribbon.
Select 'Open' from the left sidebar and then click on 'Browse' to launch the system file dialog.
In the file dialog window, change the folder view to 'Details' or 'List' view using the view icons.
If the 'Date modified' column is not visible, right-click the column headers to add it. Finally, click the 'Date modified' column header to sort your files accordingly.

Disable the Workbook Gallery on Startup
If you prefer not to see the Workbook Gallery when launching Excel, you can disable it and rely on the Open Recent list or standard file browser.
Enjoy Better File Management with WPS Office
If Excel's rigid Workbook Gallery limitations slow down your workflow, consider switching to WPS Office. It offers a free, lightweight alternative with highly customizable file management, a familiar user interface, and seamless migration.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and Launch: Follow the on-screen prompts to install the software quickly, then launch WPS Spreadsheets.
- 3. Manage Your Files: Use the recent files tab or the built-in document manager to easily view, sort, and organize your .xlsx documents exactly how you prefer.

Frequently Asked Questions
Can I force the Excel Workbook Gallery to sort by modified date?
No, Excel does not provide a built-in feature to change the primary sort order of the Workbook Gallery from 'Last Opened' to 'Modified Date'.
How do I find recently modified files if I cannot use the Gallery?
The most reliable method is to use the 'File > Open > Browse' dialog in Excel, switch to the Details view, and click on the 'Date modified' column header to sort your spreadsheets.
Why does Excel only sort by 'Last Opened' by default?
Microsoft designed the Workbook Gallery as a quick-access screen for files you interact with most frequently, operating on the assumption that recently opened files are the ones you are most likely to need again immediately.




