Printing Header on Just the First Page

  • Thread starter Thread starter Guest
  • Start date Start date
G

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