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

Many thanks.

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

"Andrew Chalk" wrote in message
...
How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.

Thanks!

To you and JE.

- A
"Paul B" wrote in message
...

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

"Andrew Chalk" wrote in message
...
How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.

Select cell A2 and choose Window/Freeze Panes


In article ,
"Andrew Chalk" wrote:

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

Many thanks.

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

Many thanks.
"Andrew Chalk" wrote in message
...
How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.

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!
==============================================


"Andrew Chalk" wrote in message
...
What about freezing the left column, so that it is always visible as I
scroll to the right?

Many thanks.
"Andrew Chalk" wrote in message
...
How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.

Thanks to you and Pete. Now I see the logic ...

- A
"RagDyer" wrote in message
...
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!
==============================================


"Andrew Chalk" wrote in message
...
What about freezing the left column, so that it is always visible as I
scroll to the right?

Many thanks.
"Andrew Chalk" wrote in message
...
How do I make the top row of a spreadsheet a "nn-scrolling" header row?

Many thanks.

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

Pete