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.
 
Back
Top