Repeat Rows at Top - Except Final Page

G

Gandor

Is it possible to repeat rows at the top of each page, but not for the Final
Page?

For instance I repeat rows 1 and 2 and have page breaks for a total of seven
pages. I want the repeated rows on pages 1-6 but not my totals page which is
page 7.

Thanks.
 
G

Gord Dibben

Not possible in one print job.

Two separate print jobs.

pages 1-6 with rows to repeat then page 7 without.

You could do it with VBA but will still be two print jobs.


Gord Dibben MS Excel MVP
 
S

Sean Timmons

Short of performing some VB magic that I'm not aware of, no. you can creat
manual headers within the sheet to avoid this, though that's not very
professional looking...
 

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

Rows to Repeat on Top of everypage EXCEPT for two pages 1
Page numbering with Merged Document and IF statements 1
Space at end of multi page list to accommodate new entries 1
Indenting every other paragraph in Word at the same time? 0
Section and Page numbering 0
Printing all columns 0
MS Word Page Layout/Break/Margin Issues, help 0
How to open multiple instances of Word 365? 5

Top