excel

D

dbasco

I am trying to sort information in excel. Here is an example:

Name Date of Hire Race Sex

I want to sort by date of hire in an ascending order and make the other
information move with the date as it changes. What do I do?
 
G

Gary''s Student

The trick is to select ALL the columns you want sorted. Then when you
pull-down sort, make sure header is checked and tell the Wizard to sort by
Hire Date.
 
G

Gord Dibben

Just make sure you select all columns before Data>Sort on Date of Hire column.


Gord Dibben MS Excel MVP
 
D

dbasco

It does not bring the other fields with the change. Maybe I did not
make it clear in the posting. When it orders the date of hire i need
the info. in the other columns to move with the correct date.
 
G

Gord Dibben

Your original description was clear........at least to myself.

That's why you pre-select all columns together before you sort on the one
column.

Name, Race and Sex with stay with Date of Hire row.


Gord

It does not bring the other fields with the change. Maybe I did not
make it clear in the posting. When it orders the date of hire i need
the info. in the other columns to move with the correct date.
Click to expand...

Gord Dibben MS Excel MVP
 
Top