ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Favorites in Excel (https://www.excelbanter.com/setting-up-configuration-excel/91744-favorites-excel.html)

sphbecker

Favorites in Excel
 
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?

Nick Hodge

Favorites in Excel
 
Gone I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"sphbecker" wrote in message
...
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?




Dave Peterson

Favorites in Excel
 
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"

sphbecker wrote:

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?


--

Dave Peterson

Gord Dibben

Favorites in Excel
 
FileOpen to get the dialog box.

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

When active, hit ToolsAdd to "My Places".


Gord Dibben MS Excel MVP

On Thu, 1 Jun 2006 13:50:02 -0700, sphbecker
wrote:

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?




All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com