logo

Adjust the Number of Recently Opened Files in Excel

Excel 2007 NL tips
Featured

Never Search for Files Again

Recently opened files 00

The number of Excel files a user typically works with is usually limited to about 10. Under >> Recent Documents, Excel shows only a limited number by default. However, you can change how many recently opened Excel files appear in the list. By increasing it to the maximum of 50, you can avoid having to search for your files.

 

Steps to Adjust This Setting

  • Click the >> Office Button
    Recently opened files 01
  • Select >> Excel Options
    Recently opened files 02
  • Go to the Advanced tab
    Recently opened files 03
  • Scroll to the Display section on the right side of the screen
  • Adjust the setting for >> Show this number of Recent Documents to the desired value. The maximum allowed is 50
    Recently opened files 04