View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Sorting Alphabetically

Hi,

Here are two other ways that don't require the Sort dialog box:

1. If your data is well organized with one row of titles just select a
single cell in the column you want to sort on and click the Ascending or
Descending sort buttons. You don't necessarily need to select all the data
before sorting, if the data is set up correctly.
2. Select all the data and then press the Tab key until the active cell is
in the column you want to sort on then click the Ascending or Descending sort
buttons.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vicki" wrote:

I would like to sort a column alphabetically and make sure that the info in
the other columns stay with the sorted column. I realize that I must select
all of the columns, but how do I indicated which column is to be sorted after
all columns are selected?
Advice appreciated!
Vicki