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.

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


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.

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

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.

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

  • 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.

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

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

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

  • 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:


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.

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

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

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

  • 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.

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

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.

print excel sheet with header on every page

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

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

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

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo