Printing headers on all pages except the first

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

Guest

How can I print headers in a workbook on every page except the first when the
first worksheet is more than one page?
 
If you use the top rows of your spreadsheet as the header that is simple.
start with say a page break before row 50 (set in row 50), Then
file, page setup, sheets, rows to repeat at top: $50:$50
of course you will not be able to freeze the rows to see the column headers
at that point for display because the must be first row(s) at the top.

Does that suffice. If it has to be the real headers then you print
only the first page with a macro, insert the headers in the macro,
and print the remaining pages. modify the following:

Change header or footer for each page: How to find the number of pages in a worksheet and how to change the header or footer from
page to page, see posting, Myrna Larson, 1999-12-16;
http://google.com/[email protected]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

printing a header in Excel 2
Access Page Header with merge field 0
Printing header rows.. 5
header 1
Header/Footer on First Page 1
Printing 36069 pages 1
Print on only one page 5
Insert Page Numbers on Worksheet in Excel 2007 6

Back
Top