| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freezing column and sorting
If you have data to sort in columns A through H, is there a way to freeze
column A the sort the remainder (B-H) without affecting A? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freezing column and sorting
What do you mean 'freeze'? If you want Col A to remain in the order it is and
Sort on B-H then choose only Col B-H and sort. "BobW" wrote: If you have data to sort in columns A through H, is there a way to freeze column A the sort the remainder (B-H) without affecting A? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Freezing column and sorting
You don't want the cells in column A to move with the rows when you sort
the B-H columns? Don't select A for Sort, only B-H. BobW wrote: If you have data to sort in columns A through H, is there a way to freeze column A the sort the remainder (B-H) without affecting A? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
| Freezing headers and first column? | Excel Worksheet Functions | |||
| Freezing column headings | Excel Worksheet Functions | |||
| How do I limit sorting a column to the column? | Excel Worksheet Functions | |||
| Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
Linear Mode
