How to Improve the Recently Used File List in Excel

How to Improve the Recently Used File List in Excel

All right thanks for joining us for yet another excel podcast. Today we’re going to talk about the recently used file list, that’s the list of files at the bottom of the file menu you chose file usually, in Excel you’ll see the last four files that you open. Well that’s great if you only work in four different files but what if you have more files? It would be really useful they recently use file list could show us more.

It turns up that it is possible to do if we go to the tools menu and then choose options, the options dialogue is one of the most difficult in lot of excel because there are thirteen different tabs here but it turns out that what we need is the general tab, the general tab is the fourth one along the bottom row of tabs and there is an option there for the recently used file list and when excel is installed, it set up to just show just the most recent four files.

Well use the spin button to kick that up to the maximum which happens to be nine, click okay and you will think that all of the sudden we’re going to see the last nine files in the file list but we don’t, it still only shows you four, you’ll have to open a few more files manually to have those added to the list.

Here we have five as you open more files you’ll eventually have nine and it will always shows the last nine files. That’s the recently used file list, thanks for watching today check back tomorrow for another tip from Mr. Excel.


Transcription by: Scribe4you Transcription Services