How do I match all columns into descending order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kiwi Jane - 12 Oct 2006 22:50 GMT

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?

Reply to this Message

Don Guillett - 12 Oct 2006 23:08 GMT

have you looked in the help index for SORT

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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?

Reply to this Message

Gord Dibben - 13 Oct 2006 01:10 GMT

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

>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?

Reply to this Message

Rate this thread: