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

%3CLINGO-SUB%20id%3D%22lingo-sub-1903092%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20freeze%20panes%20for%20only%20a%20portion%20of%20a%20document%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1903092%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20excel%20document%20has%20two%20sections.%20I'd%20like%20to%20use%20freeze%20panes%20or%20similar%20to%20freeze%20the%20top%203%20header%20rows%20for%20example%20but%20only%20up%20to%20row%2050%20in%20the%20document.%20From%20row%2050%2C%20i'd%20like%20to%20stop%20freezing%20those%20rows%20and%20freeze%20rows%2050-52%20for%20the%20next%20section.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1903092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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?

4 Replies
Highlighted

@Doppk 

 

Hi there,

 

There three kinds of freezing:

1 - Unfreeze Panes

2 - Freeze Top Row

3 - Freeze First Column

Please see the following picture:

Ilgar_Zarbaliyev_0-1605733855309.png

 

 

I think you can use Split Command (View Tab) .

 

 

 

 

 

 

Highlighted

@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.

Highlighted

Hello @Doppk,

 

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

PReagan_0-1605796352503.png

 

Highlighted