Printing a Different Row Heading Mid-way through a Spreadsheet

M

Mamie Anding

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cels in a row that correspond to the heading of a column 2
how do I have a heading row repeat on each page while working? 2
How to reference a column heading in a cell automatically? 5
How to copy a whole Excel spreadsheet page in 2007 vs 2003? 2
Problem with Heading Rows Repeat in a table 1
Tables - Heading row repeat making it a default. 1
How to set a custom header as a row from the spreadsheet? 2
How do I get info from cell in a row by column heading 3

Top