How to Clear Recent Documents in Excel (3 Effective Ways)

Method 1 – Using Excel Options Feature to Clear Recent Documents

Steps:

  • Go to the File tab.

how to clear recent documents in excel

  • Click on Options.

Using Excel Options Feature to Clear Recent Documents

  • In the Excel Options window, select Advanced, go to the Display.
  • Set ‘Show this Number of Recent Workbooks’ to 0 (zero).
  • Click OK.

The recent documents will be removed from the history.


Method 2 – Clear Unpinned Workbooks Applying ‘Remove from List’

Steps:

  • Go to the File menu, Recent
  • Right-click on any of the recent documents that you want to remove and select Remove from List.
  • This command will remove that recent document.

Applying Remove from List or Clear Unpinned Workbooks Function to Clear Recent Documents

  • To clear all the recent documents, go to More Workbooks. This option is at the right bottom corner of the Recent tab.

  • In the Workbooks tab, right-click on any of the recent documents and select Clear unpinned items.

  • Click Yes in the pop-up window.

Implementing VBA to Clear Recent Documents

  • All recent documents will be removed from the history.

Applying Remove from List or Clear Unpinned Workbooks Function to Clear Recent Documents

Read More: How to Clear Excel Temp Files


Method 3 – Implementing VBA to Clear Recent Documents

Steps:

  • Go to the Developer tab, select Visual Basic.

Implementing VBA to Clear Recent Documents

  • The VBA editor will appear. Select Insert >> Module to open a VBA Module.

  • Enter the following code in the VBA Module.
Sub ClearRecentDocuments()
On Error Resume Next
Do Until Err.Number <> 0
Application.RecentFiles.Item(1).Delete
Loop
End Sub

The code uses a Do Loop statement to remove all the recent documents from the history.

  • Go back to your sheet and run the Macro named ClearRecentDocuments.

  • Go to the File tab to check if all the recent documents are removed from the history.

Implementing VBA to Clear Recent Documents

Read More: Difference Between Delete and Clear Contents in Excel


Related Articles


<< Go Back to Clear Contents in Excel | Entering and Editing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Meraz Al Nahian
Meraz Al Nahian

Md. Meraz Al Nahian has worked with the ExcelDemy project for over 1.5 years. He wrote 140+ articles for ExcelDemy. He also solved a lot of user problems and worked on dashboards. He is interested in data analysis, advanced Excel, statistics, and dashboards. He also likes to explore various Excel and VBA applications. He completed his graduation in Electrical & Electronic Engineering from Bangladesh University of Engineering & Technology (BUET). He enjoys exploring Excel-related features to gain efficiency... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo