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.)

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

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