excel spreadsheet sorting

J

Joecool

I have an Excel spreadsheet. I have basically three columns. The info in the first column relates to the second and third column. I want to alphabetize the first column, but when I do, the 2nd and 3rd column do not sort with it. This jumbles the relative data. How can I tie the cells together? So when the firts cell sorts, the second and thrid column sort also?
 
J

Jason Morin

Select all 3 columns prior to sorting.

HTH
Jason
Atlanta, GA
-----Original Message-----
I have an Excel spreadsheet. I have basically three
Click to expand...
columns. The info in the first column relates to the
second and third column. I want to alphabetize the first
column, but when I do, the 2nd and 3rd column do not sort
with it. This jumbles the relative data. How can I tie the
cells together? So when the firts cell sorts, the second
and thrid column sort also?
 
F

Frank Kabel

Hi
select the entire data range before sorting column A

--
Regards
Frank Kabel
Frankfurt, Germany

Joecool said:
I have an Excel spreadsheet. I have basically three columns. The info
Click to expand...
in the first column relates to the second and third column. I want to
alphabetize the first column, but when I do, the 2nd and 3rd column do
not sort with it. This jumbles the relative data. How can I tie the
cells together? So when the firts cell sorts, the second and thrid
column sort also?
 
Top