View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Change print titles (rows to repeat at top) on subsequent pages

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.