MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing Header Row (when multiple page breaks)

Posted by Scott_ on August 29, 2001 7:07 AM

I have a 3 column document that has had sub-totals calculated (with the sub-total function) along with page breaks at each subtotal value. When I print the document, the header row is printed on the first page, but all other pages (each new subtotal) do not have the header row - just the data.

How can I have the header row printed on each sheet above the data (in the first row of each sheet)?


Posted by Troy on August 29, 2001 7:33 AM

Set your print range below the line you want repeating. Under page setup, select "sheet", then select rows for "rows to repeat at top"