freeze panes - freezes first 6 rows when only 1 required

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.
 
G

Gord Dibben

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top