Favorites in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sphbecker - 01 Jun 2006 21:50 GMT

In Excel 2002, the Common Dialog box (the thing that pops up when you do
File-Open) had a shortcut to Favorites. A few users really became accustom
to using that and are wondering how to enable that feature in Excel 2003
(where it does not appear by default). I looked around a little bit and
didn’t see an option. How is this done?

Reply to this Message

Nick Hodge - 01 Jun 2006 22:09 GMT

Gone I'm afraid

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> In Excel 2002, the Common Dialog box (the thing that pops up when you do
> File-Open) had a shortcut to Favorites. A few users really became
> accustom
> to using that and are wondering how to enable that feature in Excel 2003
> (where it does not appear by default). I looked around a little bit and
> didn't see an option. How is this done?

Reply to this Message

Dave Peterson - 01 Jun 2006 22:41 GMT

Do File|open
in the top right corner, you'll see Tools.
Click on that and you'll see a "add to my places" option.

You can traverse to any folder and add it to "my places".

In fact, you can go to Favorites (and add shortcuts to your favorite folders
there) and put Favorites in "my Places"

> In Excel 2002, the Common Dialog box (the thing that pops up when you do
> File-Open) had a shortcut to Favorites. A few users really became accustom
> to using that and are wondering how to enable that feature in Excel 2003
> (where it does not appear by default). I looked around a little bit and
> didnât see an option. How is this done?

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 01 Jun 2006 23:10 GMT

File>Open to get the dialog box.

In "Look in:" scroll to your Favorites Folder in Documents and Settings.

When active, hit Tools>Add to "My Places".

Gord Dibben MS Excel MVP

>In Excel 2002, the Common Dialog box (the thing that pops up when you do
>File-Open) had a shortcut to Favorites. A few users really became accustom
>to using that and are wondering how to enable that feature in Excel 2003
>(where it does not appear by default). I looked around a little bit and
>didnt see an option. How is this done?

Reply to this Message