Freeze Panes (Both Rows & Columns)

[Jesling]

Hey guys, I am currently facing a problem to freeze panes. You can see from the picture attached below, I would like to freeze the columns after year as well as the rows below the table heading. I select the cell (with 5%) but it freeze the whole things up until the rows above (where my subject & title above already being chopped off if I scroll to the right in this case)

Anyone know how to solve this problem? I want it to be freeze so that I can see the subject up there as well as the number of years still when I scroll to the right 

Thank you. 

[#2]

Hi @Jesling 

this is just the way how freeze pane is working. If you have large subjects, like in your case, it will always be chopped off, when you scroll. There is no way to avoid that (apart from reducing the font size of the subject etc.)

[#3]

I have a different problem, I want to freeze the top row AND the first column. Can that be donel

[#4]

@arryla40 

Yes.

Select cell B2 - the cell below the first row and to the right of the first column.

Activate the View tab of the ribbon.

Click the Freeze Panes drop down.

If the first item is Unfreeze Panes, click that to remove current frozen panes, if any.

Then select Freeze Panes > Freeze Panes.