Repeating Row to Top of Each Page in Excel

In this function, we will learn how to repeat rows at the top of each page when the pages are printed without adding a header.

For this story, I would like to have the title, The Wizard of Oz, at the top of each page when it prints without me having to type it at the top of each page.

Click on File. Then click Page Setup.

Once you click on Page Setup a dialog box will appear. At the top of the box, there will

a tab Sheet.

Click on Sheet.

Second option down is Print Titles. Click in the address bar for Rows to Repeat at top:

Once you click that box, click on the 1st row of the page which contains the title.

Click OK.

The title will show at the top of each page when printed.

If you would like to check to make sure you did it correctly, click Print.

Use the arrows at the top of the preview to move to the next page. If done correctly,

it will show on all pages here.