Change the number of the most recently used workbooks

Excel 365 2016 2013 2010 2003
Having your 9 or 17 most recently used workbooks on the Office Button menu is handy, but you may find it's not enough. You can increase the number shown up to 50, and you can pin (fasten) particular workbooks to the menu so that they remain there even if you haven't used them recently.

To customize the Office Button menu, follow these steps:

   1.   Click the Microsoft Office Button ms office button , and then click Excel Options:

Excel 2007 Options

   2.   Choose the Advanced tab and then scroll down to the Display section:

advanced options Excel 2007

   3.   In the Show this number of Recent Documents box, set the number of workbooks you want to have on the Office Button menu. You can choose any number between 0 and 50 (inclusive).

   4.   Click the OK button.

When you increase the number in the Show this number of Recent Documents dropdown list, Excel doesn't add the extra files immediately to the list on the Office Button 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.)

To make Excel keep a particular workbook on the Office Button menu, open the menu, and then click the pin next to the file's name. Word pushes in the pin to indicate that the document is "pinned" in place, and then keeps the file in that place on the list until you unpin it by clicking the pin again.

pin in Excel 2007

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.