Panel Freeze, what a header

[Hagman]

Hello, I got an excel sheet with both the row and column freezed. I would like to have header but that header is scrolled away when I scroll to the right. Are the a way to have the first row not scrolled when you freeze both the row and the column

/Jim

 

[jasonb75]

The header scrolls with the data, if you could do what you're asking (which you can't) then the data that you are scrolling in the lower rows would have the wrong headers.

 

[Hagman]

@jasonb75 I do not understand.

 

[jasonb75]

What you are asking can not be done.

The link below contains a video clip that shows you the various options for freezing rows and columns.

Freeze panes to lock rows and columns - Microsoft Support

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

support.microsoft.com