How to Set Header in Excel for All Pages (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

When working with Excel, we frequently need to set a header to our Excel sheet for a better understanding of our data. Now, you can do it in an intelligent way rather than writing and styling it manually on your own. In this article, I will show you 2 quick ways to set the header in Excel for all pages.

Table of Contents hide

Download Practice Workbook

2 Quick Ways to Set Header in Excel for All Pages

1. Using the Print Titles Tool

2. Using the Header & Footer Tool

Set Header in Excel for All Worksheets

Conclusion

Download Practice Workbook

You can download our practice workbook from here for free!

Set Header for All Pages.xlsx

2 Quick Ways to Set Header in Excel for All Pages

Say, you have a sales report for different products for the first quarter of the year. Now, you want to set a header as “1st Quarter’s Sales Report” for all pages of this sales report. You can follow any of the 2 quick ways to accomplish this.

In this article, we have used the Office 365 version of Microsoft Excel. But, no worries. You can apply all of these ways to any version of Excel that is available to you. If you face any problems regarding versions, please feel free to comment below.

1. Using the Print Titles Tool

You can use the Print Titles tool of Excel to set a header for all pages in Excel. Follow the steps below to accomplish this.

📌 Steps:

At the very beginning, select your print area >> go to the Page Layout tab >> Print Titles tool.

Consequently, the Page Setup dialogue box will appear.
Subsequently, go to the Header/Footer tab of this window.
Following, click on the Custom Header… button.

At this time, the Header window will appear.
Following, at the Center section: pane, write your heading (“1st Quarter’s Sales report”) and click on the OK button.

Asa result, your header is set.
Now, to preview, click on the Print Preview button on the Page Setup window.

As a result, your heading is set to print for all pages. And, you will see the print preview like the following.

2. Using the Header & Footer Tool

Besides, you can use the Header & Footer tool for setting a header in your Excel sheet. Go through the steps below to do this.

📌 Steps:

First and foremost, select the print area >> go to the Insert tab >> Text group >> Header & Footer tool.

As a result, you will see you will have header spaces over your print area.
Now, if you want your header in the center, click inside the center part and write your desired header (“1st Quarter’s Sales Report”).

Thus, you can set the header for all pages in Excel. For instance, the outcome should look like this.

Similar Readings

Set Header in Excel for All Worksheets

Now, what if you have multiple worksheets in your workbook and you want the same header for each sheet? You can do this quickly and easily by following the ways below.

📌 Steps:

First, hold the Ctrl key and select all the worksheets where you want the same header.

Next, select your print area >> go to the Page Layout tab >> Page Setup icon.

As a result, the Page Setup dialogue box will appear.
Subsequently, go to the Header/Footer tab and click on the Custom Header… button.

At this time, the Header window will appear.
Following, at the Center section: pane, write your desired header (“1st Quarter’s Sales Report”) and click on the OK button.

As a result, the Page Setup window will appear again.
Here, click on the Print Preview button.

As a result, you will see that all the worksheets of the Excel file will have the same header and that is “1st Quarter’s Sales Report”. For example, the output should look like this.

Conclusion

So, in this article, I have shown you 2 quick ways to set the header in Excel for all pages. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.

And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!