SORTING CELLS

[LAURA]

I AM TRYING TO CREATE AN EXCEL DOCUMENT WITH 5 DIFFERENT ROW HEADINGS..FOR
EXAMPLE..ONE SAYS PURCHASE ORDER, ONE SAYS WORK ORDER, ONE SAYS DATE. I
WOULD LIKE TO KNOW IF I CAN CLICK ON EACH CELL AND IT WILL SORT
AUTOMATICALLY. I KNOW I CAN INDIVIDUALLY SORT EACH ROW BUT I NEED THEM ALL
TO SORT JUST BY CLICKING AUTOMATICALLY

 

[David Biddulph]

Please get your caps lock key repaired so that you can stop SHOUTING.

 

[Gord Dibben]

After you fix the caps lock key please post back with answers to a couple of
questions.

1. When you use the word "Row" do you really mean "Column"?

2. Do you want all the columns to sort together or separately?


Gord Dibben MS Excel MVP