Print Formatting : Show header rows show on every page

Today I want to discuss how to print header rows on every page of your worksheet. In this example I have a highlighted header row. I would like to have this header row printed at the top of every page of this report. This will help the reader understand what the columns represent on all pages of my document.

Start by selecting the page layout tab and then open the Page Layout dialog box.

On the Sheet tab of the Page Setup dialog box, click on the rows to repeat at top.

Clicking on the row you want to appear at the top of each page will populate the Page Setup – Rows to repeat at top dialog box. When done return to the Page Setup dialog box by hitting the enter key.

Select the OK button to complete the setup.

Now whenever you print preview or print your worksheet, the row you selected will be repeated at the top of each page.