How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)

There are many kinds of print types in Microsoft Excel. The print Excel sheet with the header on every page is one of them. It is an eye-catching print type. We will print an Excel sheet with the header on every page. Today, in this article, we’ll learn three quick and suitable ways how we can print Excel sheets with the header on every page in Excel effectively with appropriate illustrations.

How to Print Excel Sheet with Header on Every Page in Excel: 3 Suitable Ways

Let’s say, we have a dataset that contains information about the salary statements of the sales representative of the Armani Group. We will print Excel sheets with the header on every page in Excel of the salary statements of those sales representatives by applying Print Titles, File ribbon, and so on. Here’s an overview of the dataset for today’s task.

1. Apply Print Titles Command to Print Excel Sheet with Header on Every Page in Excel

Either you need to add a header or use a predefined header to print on every page in Excel. We can print Excel sheets with the header on every page by using the Print Titles command. Just follow the steps below to learn!

Step 1:

First of all, from your Page Layout ribbon, go to,

Page Layout → Page Setup → Print Titles

Step 2:

After clicking on the Print Titles option, a Page Setup window will instantly appear in front of you. From that window, firstly, click on the Sheet Secondly, write down $4:$5 on the Rows to repeat at top box under the Print titles option. Finally, press OK.

Step 3:

Hence, we will go back to our worksheet. After that, press Ctrl + P on your keyboard simultaneously.

As a result, we will be able to see that our Print Preview is showing the preview of the worksheet with the header that has been given in the below screenshot.

To check the other page with the header, just click on the arrow sign(➤) and you will be able to see that the Print Preview is showing the preview of the worksheet with the header.

Finally, we will click on the Print option like below to print Excel sheets with the header on every page of our worksheet.

2. Use Arrow Button to Print Excel Sheet with Header on Every Page in Excel

We can also print Excel sheets with the header on every page by using the Arrow button command. Let’s follow the steps below to learn!

Step 1:

First, from your Page Layout ribbon, go to,

Page Layout → Page Setup → Print Titles

After clicking on the Print Titles option, a Page Setup window will instantly appear in front of you. From that window, firstly, click on the Sheet Secondly, write down $4:$5 on the Rows to repeat at top box under the Print titles option. Finally, press OK.

Step 2:

Now, simply repeat step 3 of method 1, then you will be able to print Excel sheets with the header on every page.

3. Use File Menu to Print Excel Sheet with Header on Every Page in Excel

Last but not least, we can print Excel sheets with the header on every page from the File menu in Excel. This is an easy and time-saving task. Let’s follow the instructions below to learn!

Step 1:

First, select the entire data range and then click on the File ribbon.

Hence, a new window will appear in front of you. We will click on the Print option from that window.

After clicking on the Print option, another window with different Print options will now appear. We will click on the Page Setup option written in green color.

Further, a window named Page Setup pops up. From the Page Setup window, firstly, click on the Sheet Secondly, write down $4:$5 on the Rows to repeat at top box under the Print titles option. Finally, press OK.

Step 2:

Now, we will see that our Print Preview is showing the preview of the Excel sheets with the header on every page that has been given in the below screenshot.

If everything is ok, we will click on the Print option like below to print Excel sheets with the header on every page.

Things to Remember

↪ You can press CTRL+P to activate the Print feature of Excel.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Print Excel Sheets with Header.xlsx

Conclusion

I hope all of the suitable methods mentioned above to print Excel sheets with the header on every page will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.