Printing Header on Just the First Page

[Guest]

I hate asking this, but can't find the simple answer anywhere. I want to
print a spreadsheet with several pages, but want the header to appear at the
top of just the first page and not repeated on subsequent pages. How?

Thank you.

 

[David McRitchie]

As long as you use the top rows of the spreadsheet instead of
the header this is very simple.

On the first row of the second page you would insert a page break
and on page setup, sheets, you would use your
rows to repeat something like $57:$57

Details for Logo on first page
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

Details for choosing a later point for repeating lines during printing
Repeat Rows/column headings when printing (#printing)
http://www.mvps.org/dmcritchie/excel/freeze.htm#printing
You do not have that flexibility for display on your monitor, where you
have to start from to top row when you freeze.