Have you printed a worksheet with multiple pages, but wished the header would appear on each page?

1) Click Print Titles.

2) On the Sheet ta, click once in Rows to repeat at top:, then click the far-left of the row to repeat (A1), click OK, the print.

Now my header Header 1, Header 2,… will be at the top of every printed page.