Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Open File" listed in reverse-alphabetical order.
When opening files in Excel all the files and folders are listed alphabetically, with folders grouped first, then files. Suddenly all the files and folders listed in the "Open" window are listed in reverse-alphabetical. This is very annoying. I don't see any sort options for this window similar to windows explorer. How do I reset this to forward-alphabetical? Thanks, jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Open File" listed in reverse-alphabetical order.
Hi,
Cleck the NAME bar above the first filename to reverse the sort order. Mike "Jason" wrote: When opening files in Excel all the files and folders are listed alphabetically, with folders grouped first, then files. Suddenly all the files and folders listed in the "Open" window are listed in reverse-alphabetical. This is very annoying. I don't see any sort options for this window similar to windows explorer. How do I reset this to forward-alphabetical? Thanks, jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Open File" listed in reverse-alphabetical order.
When I try to open the file in Excel, there is no NAME bar above the files.
jason "Mike H" wrote: Hi, Cleck the NAME bar above the first filename to reverse the sort order. Mike "Jason" wrote: When opening files in Excel all the files and folders are listed alphabetically, with folders grouped first, then files. Suddenly all the files and folders listed in the "Open" window are listed in reverse-alphabetical. This is very annoying. I don't see any sort options for this window similar to windows explorer. How do I reset this to forward-alphabetical? Thanks, jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Open File" listed in reverse-alphabetical order.
There are icons at the top right on that dialog.
One of them is the View Icon. Click on that dropdown arrow on that view icon and choose Details. Then you'll have titles over each column that are clickable for sorting. Jason wrote: When I try to open the file in Excel, there is no NAME bar above the files. jason "Mike H" wrote: Hi, Cleck the NAME bar above the first filename to reverse the sort order. Mike "Jason" wrote: When opening files in Excel all the files and folders are listed alphabetically, with folders grouped first, then files. Suddenly all the files and folders listed in the "Open" window are listed in reverse-alphabetical. This is very annoying. I don't see any sort options for this window similar to windows explorer. How do I reset this to forward-alphabetical? Thanks, jason -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Open File" listed in reverse-alphabetical order.
You should see the Name bar if you go to detail view, rather than List view.
Are you seeing reverse alphabetic in List view? If you right-click in the "Open" window, does it give you the Option "Arrange Icons By ...", which includes by Name? Does that sort in ascending or descending order? -- David Biddulph "Jason" wrote in message ... When I try to open the file in Excel, there is no NAME bar above the files. jason "Mike H" wrote: Hi, Cleck the NAME bar above the first filename to reverse the sort order. Mike "Jason" wrote: When opening files in Excel all the files and folders are listed alphabetically, with folders grouped first, then files. Suddenly all the files and folders listed in the "Open" window are listed in reverse-alphabetical. This is very annoying. I don't see any sort options for this window similar to windows explorer. How do I reset this to forward-alphabetical? Thanks, jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel "extract" ranges of numbers listed in the A column? | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
linked PDF will not open "can not open specified file" is message | Excel Discussion (Misc queries) | |||
"general" cells turned into "accounting" - why and how to reverse | Excel Worksheet Functions | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) |