top row appear whilst scrolling

G

Guest

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.
 
P

Paul B

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
 
G

Guest

Select cell A2, Window menu/Freeze panes

Regards,
Stefi


„Naeema†ezt írta:
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the scrolling not include the top rows of the sheet 3
Excel Typed text appears in wrong cell 0
Title row to stay in place when scrolling down 2
Importing Excel report into Word showing headers and footers 1
Creating title/Header 2
Freeze /Split frames 4
How can I fix the position of a row 3
Sectional Freezing Panes 1

Top