Alpha sort names/numericals

[dane]

I have 2 columns. 1st column has names, 2nd has numerical values relevant to
the names. How can this data be alpha sorted and keep the same name/numerical
data.

 

[Guest]

data/sort

 

[David McRitchie]

Hi Dane,
Please state clearly what the problem is.
If you sorted and got the names sorted and the numbers did not stay with the
name then you have a problem with your (selection) range..

Use Ctrl+A to select all cell, then Data, Sort

Sorting, Some notes on sorting in Excel
http://www.mvps.org/dmcritchie/excel/sorting.htm