Repeat Rows at Top - Except Final Page

  • Thread starter Thread starter Gandor
  • Start date Start date
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.
 
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
 
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...
 
Back
Top