How to Clear and Unpin Recent Workbooks History in Microsoft Excel

Every time you open, edit, or save a spreadsheet in Microsoft Excel, the application automatically logs the workbook name and file path in its “Recent” file list. This list appears prominently on the Excel Start screen and under the File menu. While convenient for resuming active projects, this history list can expose sensitive financial document names, client directories, or personal payroll data when presenting your screen or sharing your computer with colleagues.

Clearing Individual Unpinned Workbooks from the Recent List

If you only need to remove a handful of sensitive or temporary spreadsheets from view without wiping your entire project history:

  1. Open Microsoft Excel on your computer.
  2. Click on the File tab in the upper-left corner of the ribbon to open the Backstage view.
  3. In the left-hand navigation pane, click on Open (or view the Recent section on the Home pane).
  4. Right-click on the specific workbook entry you wish to remove from the list.
  5. From the pop-up context menu, click on Remove from list.

The entry will vanish from your Recent list immediately. Note that this action only removes the shortcut history record; your actual spreadsheet file remains completely untouched on your storage drive.

Clearing All Unpinned Workbooks Simultaneously

If you want to clear your entire recent file history in a single click:

  1. Navigate to File > Open in Microsoft Excel.
  2. Right-click on any workbook entry in the Recent workbooks column.
  3. From the context menu, select Clear unpinned Workbooks.
  4. A confirmation prompt will ask: “Are you sure you want to remove all unpinned items from the list?”.
  5. Click Yes to confirm.

All temporary and unpinned workbooks will be deleted from your recent history. Any essential workbooks you previously pinned with the small pushpin icon will stay securely anchored at the top of your list.

Preventing Excel from Storing Recent Workbooks in the Future

If you handle highly confidential financial data and want to prevent Excel from accumulating a recent file trail altogether:

  1. Click on File and select Options at the bottom of the left pane.
  2. In the Excel Options dialogue box, click on Advanced.
  3. Scroll down to the section titled Display.
  4. Locate the setting labelled Show this number of Recent Workbooks.
  5. Change the numerical value to 0.
  6. Untick the box labelled Quickly access this number of Recent Workbooks.
  7. Click OK.

Setting this value to zero disables the recent file caching engine, ensuring no workbook history is logged during future sessions.

Recent Workbooks Management Comparison

Choose the management approach that best matches your security and workflow requirements:

Action Effect on Pinned Files Effect on Unpinned Files Ideal Scenario
Remove from list Unchanged (unless selected) Removes chosen file record only Hiding a single confidential spreadsheet after finishing a sensitive task.
Clear unpinned Workbooks Preserved safely at the top of the list Completely erased End-of-week desktop decluttering while keeping primary project templates pinned.
Set Recent Workbooks to 0 Disabled completely Disabled completely Shared workstations, loaner laptops, or strictly audited accounting environments.

Managing your Excel workbook history ensures your spreadsheet workspace remains tidy, professional, and free from confidential data leaks during daily office work.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.