Different Rows repeated in Excel

[dbrackeen]

Is it possible to have different rows repeat after a couple of pages? Basically I need rows 1-3 repeated on pages 1 & 2 only and then 2 different rows to print on page 3+. I hope this makes sense.

Thanks
Dianna

 

[arthurbr]

Which application are you using?

 

[dbrackeen]

I am using Excel 2003

 

[AnotherHiggins]

Sorry, but Excel just has the one option for rows to repeat at the top.

You could break your data down into two different sheets - but this should only be done for a specific report. Data should be stored together.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[dbrackeen]

Thanks, that is what I was thinking, but thought I would ask, just in case.

 

[Gavona]

You could use Custom views. (View, Custom View, Add)

First set the print range to include just the first two pages. Set the rows to repeat.
Then save these settings as a custom view.
Then do the same for the remainder of the report, saving as a different Custom View.

Now you can
View, Custom View, Show Print1
print in the normal way,
View, Custom View, Show Print2
print in the normal way.

If you switch on macro recorder you can create a simple macro to automate the printing. Something like this:

Sub PrintWorksheet()
    ActiveWorkbook.CustomViews("print1").Show
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    ActiveWorkbook.CustomViews("print2").Show
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

Gavin