Re: Sort by name

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks geo,

When I open the files in Excel with FILE > OPEN there is no columns 'Name'
'Size' 'Type' 'Date Modified'.

But when in Windows Explorer, I can sort without a problem. There must be
something I'm still missing.



"geo@OZ" <mark_fawkes@xxxxxxxxxxx> wrote in message
news:1143892277.590434.221790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This does have something to do with Excel.

I presume that you are trying to open the files with FILE > OPEN in
Excel. If you open this window, you should see the file /folder list
with the various columns 'Name' 'Size' 'Type' 'Date Modified'. If
you click on the column heading "Name" this will sort the list
alphabetically from A to Z - folder names will always be sorted
alphabetically at the top of the list, then file names automatically.
Clicking on NAME again reverses the sort order. Likewise clicking on
any of the other column headinsgs will sort by that column.

The sort selection appears to be sticky in that it will be the same
sort order when you restart Excel again (based on my limited testing).
This is not a feature that I have really looked at much, it is just one
of those things I use automatically. A similar process occurs if
looking at the files in Windows Explorer. With Explorer if you set the
sort order (and other settings such as displaying icons, list or
details - under VIEW) and then go to TOOLS > FOLDER OPTIONS > VIEW
tab then you can make the settings for the active folder to apply to
all foledrs.



.

Relevant Pages

  • Re: Sort by name
    ... When I open the files in Excel with FILE> OPEN there is no columns ... I can sort without a problem. ... you click on the column heading "Name" this will sort the list ... Clicking on NAME again reverses the sort order. ...
    (microsoft.public.excel)
  • Re: Ping the Excel gurus.
    ... able to change the sort order in Excel. ... Sort By: Total Val ... Then By: Client Name ... Once our site has been 'refreshed' am going to have to cobble up things in Excel that were an absolute doddle with a proper database 4GL. ...
    (uk.rec.motorcycles)
  • RE: Excel Sort
    ... For example, if a cell contains the text "A100," Excel Services places the ... Note If you have changed the default sort order to be case-sensitive ...
    (microsoft.public.excel.programming)
  • Re: Need a sorting solution
    ... Is your question about mail merging? ... If you want to sort what is the sort order? ... Excel '03 plus '07 beta... ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Save As, Open
    ... Restore Sort order in Open and Save dialogs ... Release the CTRL key. ... do not quit Windows Explorer by clicking Exit on the File menu. ...
    (microsoft.public.windowsxp.newusers)