top row appear whilst scrolling
 

I am creating a table in Excel and I want to know how to have the top row
(column titles) appear all the way whilst scrolling the page? I've seen it on
another Excel document but need help on how to go about creating it.

top row appear whilst scrolling
 

Naeema, select a cell in row 2, A2, 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

"Naeema" wrote in message
...
I am creating a table in Excel and I want to know how to have the top row
(column titles) appear all the way whilst scrolling the page? I've seen it
on
another Excel document but need help on how to go about creating it.

top row appear whilst scrolling
 

Select cell A2, Window menu/Freeze panes

Regards,
Stefi


€žNaeema€� ezt Ã*rta:

I am creating a table in Excel and I want to know how to have the top row
(column titles) appear all the way whilst scrolling the page? I've seen it on
another Excel document but need help on how to go about creating it.

top row appear whilst scrolling
 

Select row 2. Window menu/ Freeze panes
If you also want columns to freeze when you scroll horizontally, select a
cell, then when you freeze panes it will freeze everything above and to the
left of your selected cell.
--
David Biddulph

"Naeema" wrote in message
...
I am creating a table in Excel and I want to know how to have the top row
(column titles) appear all the way whilst scrolling the page? I've seen it
on
another Excel document but need help on how to go about creating it.

top row appear whilst scrolling
 

Thank-you very much Stefi, Paul B and David B - thanks for a very quick
response!

top row appear whilst scrolling
 

You are welcome! Thanks for the feedback!
Stefi

€žNaeema€� ezt Ã*rta:

Thank-you very much Stefi, Paul B and David B - thanks for a very quick
response!