How do I freeze a pane on Excel but leave one line unfrozen?

P

Paul S

I have frozen a pane on my SS to show my categories against data as you
scroll along, but my title ( on Row 1) disappears. I was wondering if there
is a way of unfreezing the pane just for Row 1? Or making it so the title is
constantly present
 
P

Paul B

Paul, select a cell in row 2 and then freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
G

Gord Dibben

Paul

Freezing row 1 only prevents it from scrolling as you move down, not across.

The only way to freeze say, A1:F1 would be to select G2 and freeze panes.

This would also freeze columns A:F

Perhaps experiment with window>new window then window>arrange.


Gord Dibben Excel MVP
 
Top