top row appear whilst scrolling

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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 fix the top-most 4 rows when scrolling? 1
top row stationary 9
How to make the scrolling not include the top rows of the sheet 3
Deleting rows to resize workspace 1
Importing Excel report into Word showing headers and footers 1
Excel Typed text appears in wrong cell 0
Scrolling in Excel 2
Header rows 2

Back
Top