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
Macro to repeat 2 contiguous rows to top of each page 2
repeat rows at top of page 4
Repeat different rows on top 2
Row to repeat while printing 3
Print Titles - Columns to Repeat at Left 1
How do I repeat a group of rows at the bottom of each page in Exce 5
Change print titles (rows to repeat at top) on subsequent pages 2

Top