how do I display row 1 (my column titles) as I page down in excel

J

John Schering

I want to see the column titles while I work on the spreadsheet way down on
row 200.
 
P

Paul B

John, select 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
 
B

Bob Phillips

Select cell A2, Window>Freeze Panes

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top