The poor, underused Office pushpin—Crabby's favorite weekly feature

Many Office programs display the last few files you opened in that program. This is so you can access the files you're working on quickly. In Excel, mine looks like this:

Crabby's Excel recent files list 

It's a handy feature, called the recently used files list that's turned on by default, but you can turn it off, turn it back on, or adjust the number of files that it displays. But that's not what my favorite tip is about. Ready? Here it is:

What if, during the week, you work on many files —so many in fact, that the one you work on once a week disappears from the list (because there's only so much room for recently used files)? Sometimes what an Office program thinks you want to have quick access to isn't necessarily what you want to be there. Solution? The Office pushpin.

In the graphic above, see the little grayed out pushpin Inactive pushpin on the right ? When it's in repose like that, it's not active.  However, if, for some reason, I want to make sure my Tip of the Day list (the first item in the list) is on the recently used files list ALL the time, I just click the pushpin and it then it looks like this Active pushpin. Now it joins the ranks of all the other files I "attached" with a pushpin.

Crabby's list of pushpinned items

 

Clever, huh?

 

 

 

 

 

 

 A note:

Depending on which version of Office you're using, there are various way to get to the recently used files list, and there are also different ways to customize that list. (In Office 2010, there is also the  "recent places" list (and the pushpins work there, too).

Hope this feature is something you can use; it's one of my faves.

"Little boxes made of ticky-tacky, and they all look just the same."— Pete Seeger (and the theme song from Weeds)

— Crabby

Office Blogs Comments

Comments: (12) Collapse

  • I was mostly impressed by the Beta version of Office.  The only niggles were the slow loading of Outlook and it sometimes refused to load.  Plus, it keeps losing the PST file and must be closed down and re-opened.  But I expect these issues have been fixed in the released version.

    But I have one final niggle.  Having taken the time to Beta test the software as a user and fed back faults as I found them, I'd have expected to have been given the opportunity to buy the released version at a discount.  I can buy a copy for my student sons at £41.90, but I can't get any kind of loyalty discount for buying  direct.  I'd not expect the student rate but at least something as a 'thank you'.

  • please can you help me sort this out message

    'You have exceeded the maximum number of pages supported by Microsoft Office Word'  This must be wrong my document on a Sony Vaio is ONLY 127 pages and 40k words, then the screen freezes and I have to force shut down.

    ADVICE PLEASE

    Annie

  • @a.kemp: I read this knowledge base article: support.microsoft.com/default.aspx and it acknowledges this error message for Word 2003.

    There is a "hotfix" available but ONLY for Word 2003:

    support.microsoft.com/.../KBHotfix.aspx

    Are you running Word 2003? Are you up-to-date an all the service packs and other updates? You can find Word updtes here: www.microsoft.com/.../resultsForProduct.aspx

    Hope this helps...

  • @Graham: I can't really do anything about discounts and whatnot -- they don't trust me wiht the money end of things; I'd just be giving it all away. But I can say thank you for testing out the Beta version. We realy on customers such as yourself to let us know what is and isn't working. I've forwarded your feedback to the appropriate parties. Thanks for writing.

  • I've been using the pushpin a little after my company updated to office 2007, the only application where it doesn't appear is in access2007, fortunately i don't change so many database files as excel files. Anyway, it could be handy to have the pushpin in accesss too

  • Who knew?!  And how PERFECT! Thank you SO much for sharing this!

  • @KC: I didn't know... but then...I knew! And now YOU kow! Now off you go, go spread the gospel of the Office pushpin!

  • Cool! But does this tip also works on lower version of office? I am using Microsoft office XP how can i put my favorite document on a recent document files? Is it possible? if so, please give me an idea how to do this.

  • @bluetooth marketing : As far as I know this works for 2010, 2007, 2003.

    I'm actually not sure about Office XP (2002) since it's been years since I've even see a copy. Click the File menu look at the list of recent documents there and if there is apushpin icon...then it works there too.

  • It really works! Thank you, Crabby! I do often use a lot of files, and I DO want to keep hold on a few ones, and now I can, because Ms Word 2007 remembers those little pins even between sessions!

  • @Neels: stick with me, kid—I've got about a million more little goodies like the pushpin.

  • How can I get this to work in Access 2007? It's not showing up on recently opened list, please let me know how to get it to display in Access 2007?  Thanks,

Comments

Comments: (loading) Collapse