Custom Search

Thursday, May 21, 2009

Customise Recent Documents Excel

Microsoft Excel 2007 Tips #1 -- Customise the Recent Documents List


Recent Documents List is what will appear when you click the Office Button on the top left of the workbook in the Microsoft Excel 2007. The list will display all the documents that have just been opened. You can choose to display up to 50 recent documents.

Customising the Recent Document List may come useful when you are sharing computer with others. You might even want to clear the recently used file list altogether. The video below will show you exactly how to do it.




So, in the nutshell, these are the simple steps you need to do to customise the size of your Recent Documents List:
  1. Click the Office Icon.
  2. Select Excel Options at the bottom.
  3. Choose Advanced tab on the left.
  4. Scroll down till you see Display.
  5. Then you use the Show This Number of the Recent Documents spin button to increase the number to up to 50.
In addition, to the right of each list in the Recent Documents, there is a grey thumbtack. If you click the thumbtack, you will pin that file to the list. The files will appear in the Recent Documetns List until you unpin them. To upon, simply just click on the thumbtack again.

Stumble Upon Toolbar
Digg Technorati del.icio.us Stumbleupon Reddit Blinklist Furl Spurl Yahoo Simpy

6 comments:

  1. My sister asked me an advice about crashed excel files. I advised it an one tool, which to my mind is the best solution in this and probably other cases - excel 2007 recovery.

    ReplyDelete
  2. This is the information I wanted to read because I could get excellent ideas I didn't know, that's perfect, I think I'm gonna share this information with my friends.m10m

    ReplyDelete
  3. This worked perfectly, thanx so much.

    ReplyDelete
  4. Not sure but this doesn't work for me.
    Despite being an Admin of the machine, it always reverts to 9 in the list when I set it to say 29. And if you have 9 pinned items you don't see any of the MRU documents.

    ReplyDelete
  5. Thanks for another informative web site. Where else may I get that
    type of information written in such an ideal approach? I've a challenge that I'm simply now
    working on, and I have been at the glance out for such information.


    Here is my web-site :: diet plans that work

    ReplyDelete
  6. Thе succesѕ of your business clients. You noω business consider gеtting ѕοme form of initial investment is needed?
    Not that I am gοing to ωoгk. It's not uncommon to find that you are an electrician.

    Take a look at my web-site: internet marketing mlm

    ReplyDelete