Alpha sort names/numericals

D

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.
 
D

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
 
Top