ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freezing column and sorting (https://www.excelbanter.com/excel-discussion-misc-queries/205224-freezing-column-sorting.html)

BobW

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?

Sheeloo[_2_]

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?


Bob I

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