Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have gotten my columns to have lists, but each column's data is linked with
the next. I don't know how to make sure that when I sort one column (ascending/descending order) that the appropriate data in the other 2 colums will also be sorted. Can someone please help me out. |
#2
![]() |
|||
|
|||
![]()
Hi
when sorting i have 2 rules, 1) click on one cell in your data range only or select the whole data range - don't select just a column 2) don't use the A-Z Z-A buttons on the toolbar, always use Data / Sort Cheers JulieD "recruiting coordinator in SF" <recruiting coordinator in wrote in message ... I have gotten my columns to have lists, but each column's data is linked with the next. I don't know how to make sure that when I sort one column (ascending/descending order) that the appropriate data in the other 2 colums will also be sorted. Can someone please help me out. |
#3
![]() |
|||
|
|||
![]()
The only sure way is to select all pertinent columns prior to the sort.
Or select all columns period by CTRL + A(twice in 2003) If you cannot remember to do that, have a backup ready or quickly hit the "Undo" button. Gord Dibben Excel MVP On Thu, 31 Mar 2005 14:59:02 -0800, "recruiting coordinator in SF" <recruiting coordinator in wrote: I have gotten my columns to have lists, but each column's data is linked with the next. I don't know how to make sure that when I sort one column (ascending/descending order) that the appropriate data in the other 2 colums will also be sorted. Can someone please help me out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |