ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sort column header (https://www.excelbanter.com/excel-worksheet-functions/90798-sort-column-header.html)

marathon runner

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.


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com