Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting
Could anyone tell me how to lock a column so it doesnt get sorted with the
rest of the data. I need to make a standings sheet and i dont want the 1 - 10 places to move just the teams and records. |
#2
|
|||
|
|||
When you sort the data don't select the column containing the 1-10 places and
it won't be sorted. If the column is an "interior" column (with sortable columns to both the right and left), then mose it outside the sort region. -- Gary's Student "Firekiller 7" wrote: Could anyone tell me how to lock a column so it doesnt get sorted with the rest of the data. I need to make a standings sheet and i dont want the 1 - 10 places to move just the teams and records. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |