Forum Discussion
Is it possible to freeze panes for only a portion of a document?
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 t...
Doppk simple answer: no. I would recommend making each section a different sheet and then you could add navigation buttons/links to jump to each. So scroll to bottom of section 1 and click button and it takes you to section 2 (on sheet 2). You can even have buttons to go the other way or a whole index.