Change display of recent documents/workbooks in Excel

Microsoft Excel has a feature that allows users to change the number of recent workbooks or documents shown in the Open screen. Listed below are the steps to increase or decrease the recent documents in Excel 2013, Excel 2010 and Excel 2007

Recent documents or workbooks in Excel 2013 and Excel 2010

The default value for number of recent workbooks is set to 25 and maximum allowed limit is 50

Recent Workbooks or Documents in Excel 2013 and Excel 2010

If you feel that 25 is too many and do not want to clutter with lot of recent workbooks then you can reduce this number using the option provided as part of Excel Settings.

Step 1: Click the File and select Options from the menu list.

Step 2: In the Options screen, click the Advanced Tab.

Advanced Option in Excel 2013 and Excel 2010

Step 3: Scroll down the Advanced options and navigate to Display section.

Step 4: Now use the option with caption as “Show this number of Recent Workbooks” (In Excel 2010, this will be “Show this number of Recent Documents”). Then click the OK button to confirm and save the changes.

Show this number of Recent Workbooks in Excel 2013 and Excel 2010

Excel 2013 provides additional setting to change the number recent workbooks displayed under File menu. You can enable quick access section by marking the check box with caption as “Quickly access this number of Recent Workbooks”.

Recent workbooks under File menu in Excel 2013

Quickly access this number of Recent Workbooks in Excel 2013

 

Increase or decrease recent documents in Excel 2007

In Microsoft Excel 2007, there is option available for specifying the number of recently accessed documents. This is available under Excel Options.

Click on the Excel Office button and select Excel options.

Excel Options in Excel 2007 

In Excel Option window, navigate to the Advanced link available on the left hand side.

Show this number of Recent Documents in Excel 2007

Scroll down to the Display section and specify the number of documents that needs to be shown in the Recent Document list in “Show this number of Recent Documents” field. Fewer documents would be shown of the list does not fit on the screen.

Also See: What is Quick Analysis in Excel 2013



Meet the Author

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

3 comments… add one

  • chris Feb 13, 2012, 7:50 pm

    thank you very much for this user friendly – stepbystep information. i was able to add more recent documents listing in the excel application. this will help me out a lot. hope you have a great day. chris

  • Paul Jun 4, 2012, 9:35 pm

    Exactly what I needed to help me find an old document. Thanks so much for your help.

  • Wombat Dec 14, 2012, 9:35 am

    How wasy was that. Simple and straight-forward. No techno babble. Thanks for this.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.