Open File menu sort alphabetical.

C

Celle

Using MS Office Professional Edition 2003.

In MS Excel and MS Word, when I want to open a file (File - Open) the OPEN
box has the folders and files sorted in reverse alphabetical order (Z to A).
How do I get them to sort in alphabetical order?

Until last week, the folders were sorted in alphabetical order and they have
suddenly changed to reverse alphabetical order without any input from me.
 
M

MartinW

Hi Celle,

In the file open dialog box, click on the views icon at the top
of the dialog (usually next to the create folder icon)
and go to Arrange Icons>By Name.

Doing this successive times toggles between A-Z & Z-A.

HTH
Martin
 
C

Celle

Hi Martin,

Thanks for the suggestion. I toggled several times between Icons, List,
Details, Properties etc, but the folders stay sorted Z-A. I don't have an
option to "Arrange Icons by Name" - assumed that List was the option you
meant by this.

I would welcome any other suggestions from anyone!

Celle
 
M

MartinW

Hi Celle,

That's where it is in XL2000. It may be in different places in later
versions, but the funcionality will still be there as it is supplied by
Windows and not Excel. Perhaps try right clicking on the white
space in the dialog box or ...... I'm not really sure where else
but I'm sure it will be there somewhere.

You can see the same sort of icon and right click functionality in
Windows Explorer in, I believe, any version of Windows.

HTH
Martin
 
D

Dave Peterson

Try clicking the View icon at the top right of the dialog.
Choose Details.
You'll see headers for each column
Click on the header and you'll sort by that column.
(it's a toggle, so you can sort ascending or descending)

ps. rightclick on the header and you can add more fields to the dialog.
 
J

Jaleel

Celle,

Go to File Open. In the Open box you can find your filenames and on top of
that a Name tab. Click that tab and toggle. When it comes A-Z mode, you
click cancel and close the box. Next time or at any time when you go to File
Open, it will be in the A-Z order.

Regards,

Jaleel
 
C

Celle

THANK YOU!!!!

Thank you Dave and Jaleel.

It worked! Now I see how easy it was (thanks to you) I feel all kinds of a
fool for not realising it myself.

Celle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top