Change print titles (rows to repeat at top) on subsequent pages

[Guest]

I'm working on a spreadsheet with multiple sections, where I'd like to use
the "repeat rows at top" to designate a print title for all pages in the
first section, then designate a different row to repeat for all pages in the
second section.

(This is a function that Word supports for a multi-section document.)

I can do the same thing using multiple sheets in the same file, or by
manually inserting page breaks along with repeating the appropriate header
rows so that the correct header appears at the top of each page.

However, I'd prefer to have Excel do this automatically, if this feature is
available.
Thanks.

 

[Guest]

there is 2 option in the File>Page Setup>Sheet>print titles for the rows to
repeat at the top and columns to repeat at the left.

was it helpful?

 

[David McRitchie]

You can have the 1st page with one set of column headers in print that is,
force a new page for the 2nd page and use that row as the row(s) to repeat.

Anything else would require printing 1st set of pages, change the header for subsequent
pages and print those pages -- all in a macro. Doable but not really advisable
for normal use.

You would probably be better off having two worksheets and printing them
at the same time by grouping the worksheets. When grouping sheets
don't forget to ungroup as soon as you are finished or risk severe damage.