Excel ABC order

[Duster]

Ok I was wondering is there a way to sort an entire column while sorting other columns with it... I.E.

I have column A that I want in ABC order but columns B and C that go with A so I want those sorted along with A Kind of like

Before

c   7   b
b   1   a
a   9   c

After Sorted

a  9  c
b  1  a
c  7  b

 

[Oldie]

If you just select the entire area you want to sort, just click on Data | Sort and set your criteria. The default behavior is to sort all fields, unless you make a different selection.

 

[Duster]

thanks

yeah i figured it out... i was being dumb for some reason