Header - print on first page only?

G

Gareth J Dykes

I have a spreadsheet that prints out on 3 pages of A4. However, the header
prints at the top of each page. How do I get it to print at the top of the
first page, only, please?

Gareth
 
G

Gord Dibben

Two separate print jobs are required.

You can use a macro to speed it up but it is still two print jobs.

See Ron de Bruin's site for code.


Gord Dibben MS Excel MVP
 

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

Access Sorting and grouping using multiple tables 0
Creating a print-macro that'll only print page 1? 2
Printing a large/long spreadsheet on legal size paper problem 1
printing a selection 1
Added page won't incorporate into original spreadsheet Excel 2003 7
Print Titles 1
How do I remove page numbers from the first few pages? 1
print macro 8

Top