In Excel, if you want to print multiple pages but want to create a header or title from the first row to print at the top of each page you can use the Print Titles option in Excel.
Above we have the data, and we need to set the first row as the title to print on every page. This table has more than 1000 rows of data when I try to print it, it has 23 pages to print.
Use Print Titles to Set 1 Row as a Header in Print Outs
- First, go to the Page Layout Tab ⇢ Page Set Group ⇢ Print Titles.
- After that, click on the “Print Title” button to open the “Page Setup” dialog box.
- Now from this dialog box, you need to use the option “Rows to repeat at top:”. So, click on the upward arrow that you have on the right side.
- At this point, you have a range selection input bar and you need to select the first row to specify it.
- Next, click on the down arrow from the right side to go back to the page setup.
- In the end, click OK to save the settings.
Now when printing this data, Excel will print the first row on each page.
As you can see in the above snapshot we have a total of 23 pages in the print preview, and it shows the page titles which we have specified from the first row.
Using Multiple Rows as Print Titles (Headers)
In the same way, where you have specified the first row you can also specify multiple rows to set as a print title.
You just need to select those rows and specify their address in the input bar, and after that, click OK.
But you can only specify the continuous rows, if you try to refer to the non-continued rows it will show an error.