Freezing rows in Excel doesn't extend to entire selection


I have a sample spreadsheet where I tried to freeze rows 1-20.  Only rows 1-18 froze.  ?

Ben ConnerCTO, SAS developerAsked:
Who is Participating?
parts8Connect With a Mentor Commented:
Unfreeze the panes.
Select cell A21.
Now select freeze panes.
This will freeze everything above and to the left of that cell.
Rob HensonConnect With a Mentor Finance AnalystCommented:
When applying the Freeze Panes, the cursor has to be in the row below where the freeze needs to occur and in the column to the right if also freezing columns.

For your sample, the cursor needs to be in F21 to freeze rows 1 - 20 and columns A - E.

I suspect you had selected F19 when applying the Freeze.
Ben ConnerCTO, SAS developerAuthor Commented:
Ah.  Which also explains why the VBA code didn't work.  Thanks!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.