View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default How do I sort in Excel alphabetically?

You should avoid using the sort buttons.

Instead, you should highlight the complete range that you want to sort
(CTRL_A will often get this okay), then use Data | Sort. You can now
specify which column to sort on (up to 3 columns) and whether to sort
in ascending or descending order. You can also specify if your range
begins with a header row - which will be the reason for everything but
the first item being sorted if you use the buttons.

Hope this helps.

Pete