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

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.


Download Practice Workbook

You can download our practice workbook from here for free!


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.

Sample Dataset to Set Header in Excel for All Pages

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.

Access the Print Titles Tool to Set Header in Excel for All Pages

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

Page Setup Dialogue Box to Set Header in Excel for All Pages

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

Header Dialogue Box

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

Access the Print Preview Button

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

Set Header in Excel for All Pages

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


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.

Access the Header & Footer Tool to Set Header in Excel for All Pages

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

Writing the Header

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

Set Header in Excel for All Pages

Read More: How to Use Header and Footer in Excel (3 Quick Ways)


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.

Select the Worksheets

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

Access the Page Setup Icon to Set Header in Excel for All Pages

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

Page Setup Window

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

Header Dialogue Box to Set Header in Excel for All Pages

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

Page Setup Window to Preview Print

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.

Set Header in Excel for All Pages


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!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo