Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
In excel 2003 there was available web toolbar with favorites command. That
allowed quickly to find files. For some reason web toolbar is not available in excel 2007. Is there any alternative for the favorites command or is this possibility of saving files locations just disappeared? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
Hi Kv,
In excel 2003 there was available web toolbar with favorites command. That allowed quickly to find files. For some reason web toolbar is not available in excel 2007. Is there any alternative for the favorites command or is this possibility of saving files locations just disappeared? Rightclick your QAT and select Customise QAT. Then in the category "Commands not in the ribbon" select "Document Location" and add it to your QAT. Is that the one you're after? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
You need to add it to the Quick Access Toolbar:
Press the "Office" Button 'Excel options' Customize' 'All Commands' 'Document Location' 'Add' OK Micky "KV" wrote: In excel 2003 there was available web toolbar with favorites command. That allowed quickly to find files. For some reason web toolbar is not available in excel 2007. Is there any alternative for the favorites command or is this possibility of saving files locations just disappeared? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
I don't think so. "Document Location" only shows the location of currently
open document. I'd like to save the file locations like I can save www addresses under Favorites in Internet Explorer. I have a lot of files in different folders and I can't remember the locations of all of them. "Jan Karel Pieterse" wrote: Hi Kv, In excel 2003 there was available web toolbar with favorites command. That allowed quickly to find files. For some reason web toolbar is not available in excel 2007. Is there any alternative for the favorites command or is this possibility of saving files locations just disappeared? Rightclick your QAT and select Customise QAT. Then in the category "Commands not in the ribbon" select "Document Location" and add it to your QAT. Is that the one you're after? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
Hi Kv,
I don't think so. "Document Location" only shows the location of currently open document. I'd like to save the file locations like I can save www addresses under Favorites in Internet Explorer. I have a lot of files in different folders and I can't remember the locations of all of them. Did you try? it gives you a dropdown list which shows a history of opened files. NB: did you know you can pin files on the the recently used files list so they stay put? Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacement for favorites command in Excel 2007
Navigate to your Favorites folder in the Open File Dialog, and Add it to
the "Left Pane". KV wrote: In excel 2003 there was available web toolbar with favorites command. That allowed quickly to find files. For some reason web toolbar is not available in excel 2007. Is there any alternative for the favorites command or is this possibility of saving files locations just disappeared? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access my 'FAVORITES' from Office 2007? | Excel Discussion (Misc queries) | |||
Where is the undo command in Excel 2007? | Excel Discussion (Misc queries) | |||
How to add to favorites in Excel 2007 | Excel Discussion (Misc queries) | |||
how can I access favorites in the Excel 2007 Open file command | Excel Discussion (Misc queries) | |||
how can I access favorites in the Excel 2007 Open file command | Setting up and Configuration of Excel |