![how to clear recent list in excel how to clear recent list in excel](https://cdn.extendoffice.com/images/stories/doc-excel/clear-recent-document/doc-clear-recent-file-list-2.png)
- #How to clear recent list in excel pdf
- #How to clear recent list in excel code
- #How to clear recent list in excel password
![how to clear recent list in excel how to clear recent list in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2012/04/clear-recent-documents-3.jpg)
#How to clear recent list in excel password
Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Note: With this code, the recent document lists cannot be restored. Then press F5 key to run this code, and all the recent document lists have been removed at once. VBA code: remove the recent document lists Sub Clearrecentfiles()ģ.
#How to clear recent list in excel code
Click Insert > Module, and paste the following code in the Module Window. Press the ALT + F11 keys together, and it opens the Microsoft Visual Basic for Applications window.Ģ. The following VBA code can help you to remove all the recent document lists immediately as well.ġ. This method only remove the unpinned files.Ĭlear the recent document lists with VBA code After removing the recent document lists, they are not restored any more, and this method is only applied to Excel 2010, 2013.Ģ. And a prompt box will pop out to remind you if you want to remove all the unpinned items from the list, click Yes button, and all the unpinned recent workbooks will be cleared at once.ġ. Then in the Recent Workbooks list, right click and choose Clear unpinned Workbooks from the context menu, see screenshot:ģ. Go to the recent document lists by clicking File > Recent in Excel 2010, or click File > Open > Recent Workbooks in Excel 2013.Ģ. You can also remove all the recent document lists by applying the Clear unpinned Workbooks feature.ġ. Note: If you want to restore the recent items, you can type the number back to the Show this number of Recent Documents text box in the Excel Options dialog.Ĭlear the recent document lists with Clear unpinned Workbooks function Then click OK to close this dialog, and now when you go the Recent pane, all the recent document lists have been cleared at once, see screenshots: Click Office button > Excel Options), and in the Excel Options dialog box, please click Advanced from the left pane, and then scroll down to the Display section and change the number to 0 besides the Show this number of Recent Documents text box.
![how to clear recent list in excel how to clear recent list in excel](https://www.findprotected.com/articles/wp-content/uploads/2010/03/delete-my-recent-documents1.png)
Open a workbook, and go to click File > Options (In Excel 2007. To remove the recent document lists in Excel, you can go to the Excel Options to do a little setting. Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.Ģ007-2019 and 365 Supports all languages Easy deploying in your enterprise or organization.Īmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!.Paste Skipping Hidden/Filtered Rows Count And Sum by Background Color Send Personalized Emails to Multiple Recipients in Bulk.
#How to clear recent list in excel pdf
Split Tools: Split Data into Multiple Sheets Based on Value One Workbook to Multiple Excel, PDF or CSV Files One Column to Multiple Columns.Merge Tools: Multiple Workbooks and Sheets into One Merge Multiple Cells/Rows/Columns Without Losing Data Merge Duplicate Rows and Sum.More than 20 text features: Extract Number from Text String Extract or Remove Part of Texts Convert Numbers and Currencies to English Words.Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by