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.

Download Practice Workbook

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

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

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

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.

Read More: How to Keep Header in Excel When Printing (3 Ways)

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.

Read More: How to Set Print Titles in Excel (2 Methods)

Similar Readings:

• How to Insert Logo in Excel Header (4 Easy Ways)
• Print Labels in Excel (Step-by-Step Guideline)
• How to Edit Header in Excel (6 Easy Methods)
• Change Print Area in Excel (5 Methods)
• How to Edit Footer in Excel (3 Quick Methods)

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

Last but not the 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.

Read More: How to Repeat Rows in Excel at Bottom (5 Easy Ways)

Things to Remember

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

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.

Related Articles

• How to Print Excel Sheet with Table (4 Methods + Tricks)
• Add Header in Excel (5 Quick Methods)
• How to Remove Print Titles in Excel (3 Methods)
• Add Same Header to All Sheets in Excel (5 Easy Methods)
• Excel VBA: Print UserForm to Fit on a Page (2 Methods)
• Insert a Footer in Excel (2 Suitable Ways)
• Print Titles in Excel Is Disabled, How to Enable It?