View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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?