Is it possible to freeze panes for only a portion of a document?

Question

My excel document has two sections. I'd like to use freeze panes or similar to freeze the top 3 header rows for example but only up to row 50 in the document. From row 50, i'd like to stop freezing those rows and freeze rows 50-52 for the next section. Is this possible?

doppk · Answer

Thanks!

ilgar_zarbaliyev · Answer

Doppk&nbsp;&nbsp;Hi there,&nbsp;There three kinds of freezing:1 - Unfreeze Panes2 - Freeze Top Row3 - Freeze First ColumnPlease see the following picture:&nbsp;&nbsp;I think you can use Split Command (View Tab) .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

mtarler · Answer

Doppk&nbsp;simple answer: no.&nbsp; I would recommend making each section a different sheet and then you could add navigation buttons/links to jump to each.&nbsp; So scroll to bottom of section 1 and click button and it takes you to section 2 (on sheet 2).&nbsp; You can even have buttons to go the other way or a whole index.

preagan · Answer

Hello&nbsp;Doppk,&nbsp;Alternatively, you could create a new window from the same document and arrange each window to the sections that you would like to view.&nbsp;

Forum Discussion

Is it possible to freeze panes for only a portion of a document?

4 Replies

Resources