If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I get Excel to sort files in alphabetical order, not date?
While working in Excel somehow it changed. When I used to open files, they
would appear in alphabetical order. Now they appear in date order by last date used. Can someone please tell me how to fix this? |
#2
|
|||
|
|||
Do you mean in dialog box you see after you click File, then Open? If so, if
you are any view except Details, right-click in an empty part of the box, select Arrange Icons By and choose Name. If you are using the Details view here, you can just click the name column header. On Tue, 26 Oct 2004 11:51:06 -0700, "linok" wrote: While working in Excel somehow it changed. When I used to open files, they would appear in alphabetical order. Now they appear in date order by last date used. Can someone please tell me how to fix this? |
#3
|
|||
|
|||
Click on the View icon, select "Details". Now click on the header you
require, click once more to reverse the sort order. Click Views again to select another view if required. -- Kind Regards, Niek Otten Microsoft MVP - Excel "linok" wrote in message ... While working in Excel somehow it changed. When I used to open files, they would appear in alphabetical order. Now they appear in date order by last date used. Can someone please tell me how to fix this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sort by date problem | scudooder | General Discussion | 6 | July 31st, 2004 12:56 AM |
Excel 2000 STILL hangs on sort | Jim Cobban | General Discussion | 2 | June 29th, 2004 11:22 PM |
order by date in query | Sean | Running & Setting Up Queries | 2 | June 29th, 2004 04:09 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |