How do I change the file open dialog box?
 

When I click the icon to open an excel file, the dialog box doesn't show the
file names sorted in alphabetical order anymore (regardless of the directory
I'm trying to open a file from). It appears to be some random order,
possibly the order in which I last viewed the files. How can I change it
back to the standard alphabetical sort which it's ALWAYS been before? This
is Excel 2003.

How do I change the file open dialog box?
 

In the File Open dialog, you can sort the files/folders shown by any of the
field headings in the dialog. The field it is sorted by will contain an
upward-pointing triangle in the field heading if in ascending order or a
downward-pointing triangle if in descending order. Click on the Name field
heading until you see the upward-pointing arrow by the word Name.

Hope this helps,

Hutch

"DonnaROnna" wrote:

When I click the icon to open an excel file, the dialog box doesn't show the
file names sorted in alphabetical order anymore (regardless of the directory
I'm trying to open a file from). It appears to be some random order,
possibly the order in which I last viewed the files. How can I change it
back to the standard alphabetical sort which it's ALWAYS been before? This
is Excel 2003.

How do I change the file open dialog box?
 

In the open dialogue window click on the name header, you might have clicked
the date modified.
This is a windows setting so you can open any folder not just in Excel and
do this

--


Regards,


Peo Sjoblom

"DonnaROnna" wrote in message
...
When I click the icon to open an excel file, the dialog box doesn't show
the
file names sorted in alphabetical order anymore (regardless of the
directory
I'm trying to open a file from). It appears to be some random order,
possibly the order in which I last viewed the files. How can I change it
back to the standard alphabetical sort which it's ALWAYS been before?
This
is Excel 2003.

How do I change the file open dialog box?
 

Have you tried FileOpen"View" and selected "details" then clicked on the
Name column to sort?


Gord Dibben MS Excel MVP


On Thu, 4 Sep 2008 07:40:00 -0700, DonnaROnna
wrote:

When I click the icon to open an excel file, the dialog box doesn't show the
file names sorted in alphabetical order anymore (regardless of the directory
I'm trying to open a file from). It appears to be some random order,
possibly the order in which I last viewed the files. How can I change it
back to the standard alphabetical sort which it's ALWAYS been before? This
is Excel 2003.