Printing a Different Row Heading Mid-way through a Spreadsheet
 

I have a spreadsheet of about 500 rows. Row 1 is used for the column
headings which need to repeat at the top of each page. However, those
headings need to change at row 92, which needs to repeat for every page after
that. Is this possible?

I can print the spreadsheet with a page break at row 91 and start over for
the rest of the file, but I'd rather have the data be continuous.

--
Thanks,
Mamie K. Anding
Engineering Technician II
TPW/Traffic Services
City of Fort Worth, Texas

Printing a Different Row Heading Mid-way through a Spreadsheet
 

Not possible without setting up two separate print jobs.

You could do it with VBA but would still be two print jobs.


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 12:40:01 -0700, Mamie Anding
wrote:

I have a spreadsheet of about 500 rows. Row 1 is used for the column
headings which need to repeat at the top of each page. However, those
headings need to change at row 92, which needs to repeat for every page after
that. Is this possible?

I can print the spreadsheet with a page break at row 91 and start over for
the rest of the file, but I'd rather have the data be continuous.