Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
OPEN A FILE
When I want to open a file in Excel the files list in Date Used order.
Does anyone know if I can change the Default for the Explorer so that when I hit the Icon to Open a File the "Open Box" shows the files listed in alphabetical order. Thanks |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
OPEN A FILE
Hi
Click on Name in the header above the file list. This will then sort by name instead of date. You will see a small arrow alongside name pointing either up or down. Clicking Name again acts as a toggle and you can change the sort from Ascending to Descending. The same applies to each of the other headers, Size, Type, Date or whatever other attribute you have allocated to the title bar. -- Regards Roger Govier "gunga" wrote in message ... When I want to open a file in Excel the files list in Date Used order. Does anyone know if I can change the Default for the Explorer so that when I hit the Icon to Open a File the "Open Box" shows the files listed in alphabetical order. Thanks |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
OPEN A FILE
Thanks Roger. Do you know if it is possible to change the default though so that the Name order appears every time I seek to open a file? "Roger Govier" wrote: Hi Click on Name in the header above the file list. This will then sort by name instead of date. You will see a small arrow alongside name pointing either up or down. Clicking Name again acts as a toggle and you can change the sort from Ascending to Descending. The same applies to each of the other headers, Size, Type, Date or whatever other attribute you have allocated to the title bar. -- Regards Roger Govier "gunga" wrote in message ... When I want to open a file in Excel the files list in Date Used order. Does anyone know if I can change the Default for the Explorer so that when I hit the Icon to Open a File the "Open Box" shows the files listed in alphabetical order. Thanks |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
OPEN A FILE
I would imagine it takes whatever the last setting was in Windows
Explorer / My Computer If you open Windows Explorer, sort the directory listing by Name, then I assume that is what Excel will use when you use FileOpen -- Regards Roger Govier "gunga" wrote in message ... Thanks Roger. Do you know if it is possible to change the default though so that the Name order appears every time I seek to open a file? "Roger Govier" wrote: Hi Click on Name in the header above the file list. This will then sort by name instead of date. You will see a small arrow alongside name pointing either up or down. Clicking Name again acts as a toggle and you can change the sort from Ascending to Descending. The same applies to each of the other headers, Size, Type, Date or whatever other attribute you have allocated to the title bar. -- Regards Roger Govier "gunga" wrote in message ... When I want to open a file in Excel the files list in Date Used order. Does anyone know if I can change the Default for the Explorer so that when I hit the Icon to Open a File the "Open Box" shows the files listed in alphabetical order. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |