Office Settings & Configuration

How to Show Recently Modified Files in Excel Workbook Gallery

Huma Ashraf ChHuma Ashraf Ch Oct 15, 2026 873 views

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.

How to Show Recently Modified Files in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the File Menu

Launch Excel and click on the 'File' menu located in the top ribbon.

2
Launch the Browse Dialog

Select 'Open' from the left sidebar and then click on 'Browse' to launch the system file dialog.

3
Switch to Details View

In the file dialog window, change the folder view to 'Details' or 'List' view using the view icons.

4
Sort by Date Modified

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.

Use the Browse Dialog to Sort by Modified Date
Quick Sorting: Clicking the 'Date modified' header a second time will toggle between ascending and descending order, letting you see the newest edits first.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install and Launch: Follow the on-screen prompts to install the software quickly, then launch WPS Spreadsheets.
  3. 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.
Built-in intuitive file manager that easily sorts by modified date100% compatibility with Microsoft Excel (.xls, .xlsx) formatsLightweight application that runs fast on virtually any deviceFree to download and use with a highly familiar user interface
microsoft office alternative - wps office

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.