How can Excel print titles on every page?

How can Excel print titles on every page?

1, first open the Excel table to be printed,

FILE--Page Setup

2, in the pop-up page Setup interface--worksheet tab

3. Click the button on the right side of the print header row with the mouse

4, the dialog box is reduced to one line,

5, at this time to return to Excel table interface, with the mouse click on the header row, select each page to print the title

6, then print the title line to show the range of titles we choose to print each page

7, after the confirmation can be printed, and then print the file every page has the title of the page.