How to Add Header in Excel (5 Quick Methods)

We can insert header on each page of our Excel worksheet to make it more classy and professional. Headers typically contain some fundamental information about the spreadsheet, for example page number, date, name of the workbook and so on. In this article, we are going to discuss some methods with explanations to add header in Excel.


Download Practice Workbook

Download the practice workbook from here.


5 Quick Methods to Add a Header in Excel

Suppose, we have a dataset (B4:F8) in an Excel worksheet that contains the Numbers, Names, Ages, Cities and Countries of some students. Here, we need to add a header to the worksheet. This article will guide us to insert a header using 5 quick methods. So without further delay, let’s get started.

5 Quick Methods to Add a Header in Excel


1. Use Insert Tab to Add Header in Excel

We can easily add a header to an Excel worksheet by using the Insert tab that is available in the Excel ribbon. The steps to do so are below.

Steps:

  • First, go to the Insert tab.
  • Secondly, select the Text option.
  • Thirdly, select Header & Footer from the Text group.

Use Insert Tab to Add Header in Excel

  • Now, the worksheet will switch to the Page Layout view and 3 sections for inserting the Header will be visible. Usually, the cursor remains in the middle box.

Use Insert Tab to Add Header in Excel

  • At this time, we can type header text in any of the Header sections. For example, we have typed ‘Microsoft Excel’ in the middle section.

Read More: How to Add Same Header to All Sheets in Excel (5 Easy Methods)


2. Create Header with Excel Page Layout Tab

We can also create headers in Excel by using the Page Layout tab. For this, we need to follow some simple steps. The steps are below.

Steps:

  • Firstly, we need to go to the View tab.
  • Then, go to Workbook Views and click on Page Layout.

Create Header with Excel Page Layout Tab

  • In turn, the Header section will appear.
  • Finally, just like the previous method, we can type our desired header in the sections.

Read More: How to Insert a Picture in Excel Header


3. Apply Page Setup Dialog Box to Insert Header in Excel

If we need to add a header to a single worksheet or more than one worksheet at once, we can use the Page Setup dialog box. We can also customize our header by using it. The steps to insert a header by using the Page Setup dialog box are below.

Steps:

  • In the first place, go to the Page Layout tab in the Page Setup group.
  • Subsequently, click the Page Setup Dialog Box Launcher.

Apply Page Setup Dialog Box to Insert Header in Excel

  • Therefore, a Page Setup dialog box will pop up.
  • Now, select the Header/Footer tab from the dialog box.
  • Next, go to Header and click on Custom Header to customize the header.
  • However, we can also insert a built-in header from the Header dropdown menu.

Apply Page Setup Dialog Box to Insert Header in Excel

  • After clicking the Custom Header option, a Header dialog box will appear.
  • At this moment, we can type our header in the Left section, Center section or Right section wherever we want.
  • In our case, we have typed the header in the Center section.
  • After that, click OK.

Apply Page Setup Dialog Box to Insert Header in Excel

  • Then, the header that we just typed, is visible in the Header box of the Page Setup dialog box.
  • Eventually, click the OK button.

Apply Page Setup Dialog Box to Insert Header in Excel

  • In order to show the header in the worksheet, firstly, we have to go to the View tab.
  • Secondly, click the Page Layout in the Workbook Views group.

  • Hence, the worksheet will turn into a Page Layout view and the Header will be visible at the top of the page.

Read More: How to Insert a Footer in Excel (2 Suitable Ways)


Similar Readings


4. Make a Custom Header in Excel

Not only can we add the predefined headers to Excel worksheets, but we can also create our own with custom text images and files. This method will demonstrate how to make a custom header that includes page numbers and file names. Moreover, we can add the company logo, current date and so on. The steps to make a custom header are below.

Steps:

  • To begin with, go to Insert > Text.

Make a Custom Header in Excel

  • Next, select Header & Footer in the Text group.

Make a Custom Header in Excel

  • Now, the Header sections will open up on top of the page as the page will switch to the Page Layout view.

Make a Custom Header in Excel

  • If we want to insert this Excel file name as a header then at first, we need to select the specific Header section where we want to keep the file.
  • For example we have selected the Center Section.
  • Then, go to the Header & Footer tab.
  • After that, select File Name from Header & Footer Elements.

Make a Custom Header in Excel

  • Thus, we can add the Excel file name as a header in our worksheet.

Make a Custom Header in Excel

  • Therefore, to see the file name that we just added, click on any other place outside the Header box.

  • Just like inserting a file name, we can also add a page number as a header in our Excel worksheet.
  • To do so follow the steps below:

Select a Header section > Header & Footer tab > Header & Footer Elements group > Page Number.

  • In this way, we can add a page number in our Excel worksheet.

  • Eventually, to see the page number, click outside the selected cell.

Read More: How to Insert Logo in Excel Header (4 Easy Ways)


5. Excel Preset Header Adding

Excel includes a number of pre-built headers that can be added into our file very quickly. The steps are below:

Steps:

  • First, go to Insert and select the Text option.

Excel Preset Header Adding

  • Then, select Header & Footer from the Text dropdown menu.

Excel Preset Header Adding

  • As a result, the Header section will open up on the top of the worksheet.

Excel Preset Header Adding

  • Next, go to the Header & Footer tab and click on the Header dropdown menu in the Header & Footer group.

Excel Preset Header Adding

  • Now, select any header option as you wish from the dropdown menu.
  • For instance, we selected ‘Inserting Excel Header.xlsx’ as the header.

  • In this way, we can add a preset header in Excel.

Read More: How to Insert Symbol in Excel Header (4 Ideal Methods)


How to Change a Header in Excel

Sometimes, we may need to change the header we added. Let’s say we have a datasheet (B4:F8) in Excel where we have already added a header. Now, we want to change it. Here, we will discuss some simple steps to do so. The steps are below.

How to Change a Header in Excel

Steps:

  • In the above screenshot, we can not see the header as the worksheet is in the Normal view option. If we change it to the Page Layout view then the header will be visible.
  • For this, go to the View tab > Workbook Views group > Page Layout.

How to Change a Header in Excel

  • In turn, the worksheet will transform to the Page Layout view and we will see the Header at the top of the sheet. We can see ‘Microsoft Excel’ in the Center Section of the Header box.

  • Now, to change the header just delete the previous text and type the new one. Here, we have typed ‘How to add Header’ in the replacement of ‘Microsoft Excel’.
  • In this way, we can easily change the header in Excel.

Read More: How to Edit Header in Excel (6 Easy Methods)


How to Close a Header in Excel

We often need to exit the header and footer view and return to the regular view after finishing adding the Excel header. Assuming, we have a dataset (B4:F8) in Excel where we have added a header named ‘Microsoft Excel’. To close the Header, we need to follow some simple steps below.

How to Close a Header in Excel

Steps:

  • Here, we can close the Header by shifting from the Page Layout view to the Normal view.
  • To do so, go to the View tab > Workbook Views > Normal.

How to Close a Header in Excel

  • Thus, we have closed the Header successfully. The result is in the screenshot below.

Read More: How to Hide Header and Footer in Excel (2 Easy Methods)


How to Remove a Header in Excel

Removing a header in Excel is a very easy task. Let’s assume we have an Excel dataset where we have inserted a header. However, if we want to remove the header we need to follow the steps below.

How to Remove a Header in Excel

Steps:

  • Firstly, go to the View tab and select Page Layout from the Workbook Views group.

How to Remove a Header in Excel

  • Then, the Header will appear.
  • Therefore, select the Header text box.

  • Lastly, press the Delete or Backspace key from the keyboard and thus the header will be removed properly. Therefore, we can see the result in the screenshot below.

Read More: How to Remove Header and Footer in Excel (6 Methods)


Advantages of Using Headers in Excel

For presenting the Excel data in a printable form, we can use the Header in Excel which will help the layout to look more professional. Furthermore, It saves time by eliminating the need to manually change the header of each sheet.


Things to Keep in Mind

When we add a Header in Excel, it is carried forward to all sheets. Hence, if we need to change any sheet regarding the Header, we must go to that sheet’s Header to make those changes.


Conclusion

I hope the above methods will be helpful for you to add a header in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.


Related Articles

Sagufta Tarannum

Sagufta Tarannum

Hi, I am Sagufta. I have completed my graduation in Civil Engineering from Bangladesh University of Engineering and Technology. I am very much interested about research and innovation in the field of Civil Engineering.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo