Static Header Row

A

Andrew Chalk

How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.
 
P

Paul B

Andrew, select A2 and then window, 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
 
A

Andrew Chalk

Thanks!

To you and JE.

- A
Paul B said:
Andrew, select A2 and then window, 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
Click to expand...
 
A

Andrew Chalk

What about freezing the left column, so that it is always visible as I
scroll to the right?

Many thanks.
 
R

RagDyer

Then use B2 *instead*!

Check out this old post:

http://tinyurl.com/2qdzt

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
P

Pete

Unfreeze the panes then select B2 and Window | Freeze panes again -
this will freeze row 1 and column A.

Pete
 
Top