B BobW Oct 6, 2008 #1 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?
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?
S Sheeloo Oct 6, 2008 #2 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.
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.
B Bob I Oct 6, 2008 #3 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.
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.
