How to Change the Number of Recent Documents in Excel 2011

Excel 2011 for Mac provides several ways for you to create or open documents on your computer. One fo the options available is to open recent documents that have been created or edited with the program. This is helpful if you want to save a few seconds looking for a file, but you may be uncomfortable with such simple access to your files by anyone else that is using your computer.

Fortunately Excel 2011 allows you to adjust the number of recent documents that the program shows. You can choose any option between 1 and 99, or you can elect to turn the setting off entirely.

 

Show More or Fewer Recent Documents in Excel 2011

The steps in this article will show you how to adjust the number of recent documents that Microsoft Excel 2011 for Mac shows when you click File > Open Recent. You can select any number between 1 or 99, or you can elect not to show any at all.

 

  1. Open Microsoft Excel 2011 for Mac.
  2.  

  3. Locate the Excel option at the top of the screen.
  4. find the excel option

     

     

  5. Click Excel, then click Preferences.
  6. open excel preferences

     

     

  7. Click the General button.
  8. click the general button

     

     

  9. Click inside the field to the right of Show this number of recent documents and enter the preferred amount. Again, this can be any number between 1 and 99. If you would prefer not to show any recent documents, then click the box to the left of the option to remove the check mark. Once you are done, click the OK button at the bottom of the window.

change the number of recent documents

 

 

This setting is for the entire Excel 2011 program, so it will remain at this number whenever you open another Excel file in the program.

Do you often switch between Mac and PC computers, and get frustrated because of the different scrolling behaviors on the mouse? Change the scrolling behavior on your Mac to make it more similar to what you are used to on your Windows PC.