Freeze panes for titles below row 1

David77

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows
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.

1597139529290.png
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

afonsomira

Board Regular
Joined
Aug 11, 2020
Messages
62
Office Version
  1. 365
Platform
  1. Windows
Yes you can.

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

David77

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

* 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

Well-known Member
Joined
Dec 30, 2008
Messages
11,937
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

New Member
Joined
Jun 16, 2020
Messages
45
Office Version
  1. 365
Platform
  1. Windows
Hi
Have you tried splitting? (View -> Split)

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

Thanks
Jon
 

jon1315

New Member
Joined
Jun 16, 2020
Messages
45
Office Version
  1. 365
Platform
  1. Windows
(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)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,653
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top