If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Repeat Rows at Top - Except Final Page
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. |
#2
|
|||
|
|||
Repeat Rows at Top - Except Final Page
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 On Wed, 6 Jan 2010 12:46:02 -0800, Gandor wrote: 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. |
#3
|
|||
|
|||
Repeat Rows at Top - Except Final Page
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... "Gandor" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|