freeze panes - freezes first 6 rows when only 1 required

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a spreadsheet using data copied from my Blue Cross Blue Shield
benefits website. When I try to freeze the top row (by selecting a cell, or
the whole row), the first 6 rows are frozen.
 
Mike

To freeze top row, select A2 and freeze panes.

The rules are............everything above and left of the pre-selected cell will
be frozen.

If this is not happening for you, maybe the Blue Cross data came over with some
merged cells.

Check out Format>Cells>Alignment and "Merge cells" setting.


Gord Dibben MS Excel MVP
 
Thanks for your speedy reply. Fixed!

Gord Dibben said:
Mike

To freeze top row, select A2 and freeze panes.

The rules are............everything above and left of the pre-selected cell will
be frozen.

If this is not happening for you, maybe the Blue Cross data came over with some
merged cells.

Check out Format>Cells>Alignment and "Merge cells" setting.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top