View Single Post
  #2  
Old January 6th, 2010, 09:01 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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.