View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marathon runner
 
Posts: n/a
Default sort column header

All of a sudden on an existing worksheet, when I try to sort by column, Excel
won't allow me to select the top row as my header row. The top row is a
frozen pane so that I have it as headers as I scroll down through the
spreadsheet.

The frozen row is not something I've done recently. I was previously able to
sort and when I check the use header column option, it automatically gave me
that row. Now it's picking the 2nd row.