• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Customization, Macro, and VBA... > INTERFACE CUSTOMIZATION ANNOYANCES

INTERFACE CUSTOMIZATION ANNOYANCES

EXPAND THE RECENTLY USED FILE LIST

The Annoyance:

I work with many workbooks every day, and I hate having to dig through my drives to find the files I need. The recently opened file list at the bottom of the File menu shows only the last four files I opened. How do I make it show more files?

The Fix:

Simple. Choose Tools → Options, click the General tab, and in the "Recently used file list" field set the value to 9 (the maximum number allowed). If you don't want Excel to list recently used files at all, uncheck the "Recently used file list" box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint