How to repeat top row header on every page when printing in Excel worksheet

Open the Excel worksheet you want to print, and then press the CTRL P keys simultaneously to see a print preview. If you have multiple pages in your document, by default the top row headers are not visible on any page except the first, as shown in the print preview screenshot below.

This is a huge inconvenience, but you can choose to print top row headers on every page of your Excel worksheet, like in the screenshot below.

Want to know how to do this? Well, you wouldn't believe it if I told you how easy it is to complete this task. So what are you waiting for? Let’s jump right into the article.

Solution

Step 1: First, click the PAGE LAYOUT tab at the top of the Excel window, and then click the button named Print Titles button.

Step 2: When the Page Settings window opens, click on the named Sheet Tab.

Next, under the Print title section, click the Shrink button related to the Rows to repeat at top option.

Step 3: In the next step, you just select the rows you want to repeat on all pages when printing. You can also select multiple lines if you wish to have more than 1 line repeated on all pages to be printed.

If you look at the

Page Setup - Duplicate Rows in the top window, you will see that it autofills with the rows you selected.

After selecting the row, click the small

Expand icon shown in the screenshot below to return to the "Page Setup" window.

Step 4: That’s it. You can now click the Print Preview button in the Page Setup window to verify your changes.

Step 5

: There you go! The top row you selected will now appear on every page of the printout, instead of only appearing on the first page from now on. You can go ahead and click the "Print" button to print your document.

Note:

If you were wondering how we managed to get the grid lines to appear in the print preview as well, wonder no further. Click here to learn how to add gridlines to your prints.

The above is the detailed content of How to repeat top row header on every page when printing in Excel worksheet. For more information, please follow other related articles on the PHP Chinese website!