Sorting Alphabetically

[Vicki]

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

 

[Lars-Åke Aspelin]

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

Click on Data, then on Sort. Choose the column to sort by in the
dialogue that pops up.

Further explained with pictures in the first link that is returned if
you make a Google search on
excel data sort
http://www.contextures.com/xlSort01.html

Hope this helps / Lars-Åke

 

[Fred Smith]

There's a drop down box for that. The specifics depend on which version of
Excel you have. In 2007, Data>Sort>Sort by>Column A

Regards,
Fred

 

[Shane Devenshire]

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.