View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

I see Dave answered your question, perhaps the related information
may still be of use.

For printing, file, page setup, sheets (tab)
Rows to print at top: 1:1

You probably want the same for viewing
Select row 2 if you want to repeat row 1, or
Select cell B2 if you want to retain column A and row 1
Window (menu), Freeze panes -- unfreeze to reverse process

Additional related information in
http://www.mvps.org/dmcritchie/excel/freeze.htm
http://www.mvps.org/dmcritchie/excel/logohead.htm
http://www.mvps.org/dmcritchie/excel/pathname.htm
http://support.microsoft.com/default...;en-us;Q288964 Excel 2002 picture in header/footer

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Minnow" wrote in message ...
I have a spread sheet. The first row data is the header for each column. But
they does not show on every page.

How can I make them show on every page?

I surely would appreciate any answer.