Freeze panes for titles below row 1

[David77]

Hello everybody,

Is there a way to freeze the title panes below? It seems to be that I can only freeze top and right side panes. I want to freeze these 5 panes here, so once I scroll down below A13-E13 they keep up with me.

 

[afonsomira]

Yes you can.

Just click on the 14 row, go to tab view, freeze panes anda then on freeze panes again.

 

[afonsomira]

Yes you can.

Just click on the 14 row, go to tab view, freeze panes anda then on freeze panes again.

* Selecte the
entire 14 row

 

[David77]

Yes you can.

Just click on the 14 row, go to tab view, freeze panes anda then on freeze panes again.

Thank you!!

 

[David77]

* Selecte the
entire 14 row

I have a new problem tho

If I freeze the panes, then I can't scroll above number 13 anymore.

I want to freeze the panes such that row 35 (in my actual non-test document) is always frozen and I can scroll both above it (without it following me if possible) and below it (with it following me)

if that makes sense?

 

[jasonb75]

You can only freeze 1 place in the sheet. Whatever you freeze, everything above and left is locked in place (no scrolling).

You might be able to do something by using vba to move the point at which the screen is frozen, but I suspect that it will be more trouble that it's worth.

 

[David77]

You can only freeze 1 place in the sheet. Whatever you freeze, everything above and left is locked in place (no scrolling).

You might be able to do something by using vba to move the point at which the screen is frozen, but I suspect that it will be more trouble that it's worth.

Do you know of any such solutions? or is it a lost cause?

 

[jon1315]

Hi
Have you tried splitting? (View -> Split)

I think this could be what you're after...

Thanks
Jon

 

[jon1315]

(You'd do it the same was as explained in prior answers but instead of freezing panes, click split... it will allow you to scroll both ... granted it isn't exactly what you're after but could be a useable alternative to vba)

 

[David77]

Hi
Have you tried splitting? (View -> Split)

I think this could be what you're after...

Thanks
Jon

Didnt know about this,

will try out - thank you!