• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • Last Modified:

Freezing rows in Excel doesn't extend to entire selection

Hi,

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

--Ben
freeze_sample.xlsx
0
Ben Conner
Asked:
Ben Conner
2 Solutions
 
Rob HensonIT & Database AssistantCommented:
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.
0
 
parts8Commented:
Unfreeze the panes.
Select cell A21.
Now select freeze panes.
This will freeze everything above and to the left of that cell.
0
 
Ben ConnerAuthor Commented:
Ah.  Which also explains why the VBA code didn't work.  Thanks!

--Ben
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now