How do I match all columns into descending order

[Kiwi Jane]

I have columns A-Gthat include A - Parents name, C-players name, E- Phone
numbers, and G-email address. I want to sort in Alpha order, but all cells
must match the original imput. How do I do this?

 

[Don Guillett]

have you looked in the help index for SORT

 

[Gord Dibben]

To keep data together as you sort............

Select all the columns prior to doing the sort on whichever column you wish to
sort on.

Then Data>Sort>pick a column and follow your nose.


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 14:50:01 -0700, Kiwi Jane <Kiwi