Change the number of the most recently used workbooks

Excel 365 2016 2013 2010 2007
Having your 4 most recently used workbooks on the File menu (or Getting Started pane) is handy, but you may find it's not enough. You can increase the number shown up to 9.

To customize this option, follow these steps:

   1.   Select Tools -> Options... to open the Options dialog box.

   2.   Choose the General tab:

excel 2003 options

   3.   In the Recently used file list box, set the number of workbooks you want to have on the File menu. You can choose any number between 0 and 9 (inclusive).

   4.   Click the OK button.

When you increase the number in the Recently used file list dropdown list, Excel doesn't add the extra files immediately to the list on the File menu, but rather adds them one by one as you open and close files.

If you reduce the number to 0, someone can't increase that number and immediately see which files you've been working with. (But they may be able to find that information elsewhere in the Windows operating system.)

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more