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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks