Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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. -- Gary's Student " wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
Just make sure you select all columns before DataSort on Date of Hire column.
Gord Dibben MS Excel MVP On 20 Dec 2006 15:48:56 -0800, wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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. Gord Dibben wrote: Just make sure you select all columns before DataSort on Date of Hire column. Gord Dibben MS Excel MVP On 20 Dec 2006 15:48:56 -0800, wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |