Does Excel provide an easy means of bookmarking worksheets?
Asked by
ETpro (
34605)
February 19th, 2010
I have a several worksheets that I need to open at some point nearly every day. By default, Excel shows the four most recently accessed files when I click File >> Open.
But on days when I am opening and closing a lot of spreadsheets, yesterday’s work is soon off the Most Recent Four list. Is there some way to add permanent, clickable links or bookmarks? If so, how do you do it?
Observing members:
0
Composing members:
0
3 Answers
Two ways to go about this depending on the version of Excel you have I believe if you have 2003 or great there are thumbtacks to the right of the document if you click this thumbtack it will stick to your recent workbooks list. If you have an older version of Outlook there is a way in setting to change the number of recent documents excel remembers.
Other suggestion would be to create a folder on your desktop for frequently accessed documents and put shortcuts in their to your well frequently accessed documents. :)
Hope this helps.
I have created a Master workbook with hyperlinks to frequently (and very infrequently) used Excel sheets (vacation / work time planner, budget template, shortcuts to various contract directories, etc., and I frequently add to that). I call up the Master workbook with a Custom menu choice (Tools / Master), and then just arrow down to the line that I want (that is, the specific hyperlink) and hit Enter. (I also have narrative text next to the hyperlink for those files that I only open, say, annually or otherwise infrequently, but don’t want to forget about.)
It’s sort of DOS-ish, but it works well. I also have my default set up to show the last nine opened files, instead of just four.
@limeaide Thanks. I have Office 2003. I will check out those thumbtacks you mentioned.
@CyanoticWasp That’s exactly the sort of need.
Thanks, both of you. Good info.
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.