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? |
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? |
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? |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com