View Single Post
  #2   Report Post  
Paul B
 
Posts: n/a
Default How do I freeze a pane on Excel but leave one line unfrozen?

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

"Paul S" <Paul wrote in message
...
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