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

People like to have their things decorated. Header and Footer are one of the most amazing features to decorate Microsoft Excel worksheets. If you want to use Header and Footer, I must assure you that you have found the right place to fulfill your purpose. In this article, I am going to explain 3 amazing ways on how to use Header and Footer in Excel. I hope this article will be very helpful for all of you guys.

For more clarification, I am going to use a dataset where I have arranged the information of a company’s employees in the Employee Id, Name, Department, and State columns.

How to Use Header and Footer in Excel


Download Practice Workbook


What Are Header and Footer?

A Footer is a text that is positioned at the bottom of a page, while a Header is a text that is positioned at the top of a page. Usually, details about the document, such as the title, chapter heading, page numbers, and creation date, are inserted in these spaces.


Advantages of Using Header and Footer

There are many fascinating advantages of using Header and Footer. Among them, the most amazing advantage is that you don’t have to repeat important information on every page manually. It will lessen your workload. Page numbering is just an example of it.


3 Quick Methods to Use Header and Footer in Excel

1. Applying Insert Tab to Use Header and Footer

In terms of talking about easy ways to use Header and Footer, use of the Insert tab is just one of a kind. You just need to follow the following steps to do so.

Steps:

  • First of all, go to the Insert tab.
  • Then, click on Text from the ribbon.
  • Pick the Header & Footer option.

You will be able to see the Header option at the top of the page and the Footer at the down.

Header and Footer

After applying the Insert tab to have Header and Footer options, you can customize them in two ways.

  1. Inserting Header and Footer Manually
  2. Using Preset Feature

1.1. Inserting Header and Footer Manually

You have to insert the Header and Footer with your own choice and with your own effort. In this way, you can decorate the Header and Footer according to your need.

Steps:

  • Click on the Header option.
  • Next, go to the Header & Footer tab.
  • Then, from the ribbon, there will be some options in the ribbon with that you can customize your header.

In my case, I have decided to add File Name in the middle of the Header. So, I select File Name from the ribbon.

Thus, the File name is added as a Header.

As it is a manual process, you can just write down what you want at the Header. I input SOFTEKO at the last section of the Header. So, I write it down using keyboard keys.

Customizing Header in Excel

Thus, we can have the written letters as Header.

  • For customizing the Footer, click on Go to Footer from the ribbon.

You can add the Footer following the same ways of adding the Header.

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


1.2. Using Preset Feature

There are some inbuilt features to add as Header and Footer. We can use them too.

Steps:

  • Firstly, click on the Header option.
  • Next, go to the Header & Footer tab.
  • Select the Header feature.
  • After that, there will appear some preset features. You can choose according to your choice.

Similarly, you can click on the Footer option from the ribbon to add the preset footer.

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


Similar Readings


2. Use Header and Footer with Excel Page Layout Tab

We can also use the Page Layout tab to add Header and Footer.

Steps:

  • First of all, go to the Page Layout tab.
  • Then, click on the extended button of the Page Setup group from the ribbon.

Selecting Page Layout to Use Header and Footer

A Page Setup wizard will appear.

  • Now, click on the Header/Footer
  • From the Header box, you can select a header from the available options.

  • Alternatively, you can also click on Custom Header.

A Header box will appear. There will be three sections where you can write the things that you want in the left, center, and right sections.

Similarly, you can select from the preset options as footer from the Footer box.

Alternatively, you can customize your footer similar to the header customization process from the Customize Footer option.

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


3. Using Page Layout Feature from View Tab

We can also use the Page Layout tab under the View tab to use Header and Footer.

Steps:

  • Firstly, click on the View tab.
  • Then, select Page Layout from the ribbon.

Excel View Tab Feature to Use Header and Footer

Then, you will have the header option at the top and the footer option at the bottom. You can customize the Header and Footer according to your preferences.

Read More: Add The Footer Page 1 To The Current Worksheet


How to Remove Header and Footer from Excel Sheet

You can simply remove the added Header and Footer too. For the removal of Header, you just need to go to the Header option from the Header & Footer tab and select (none). Thus, your Header will be removed.

Remove Header and Footer in Excel

Similarly, select (none) from the Footer option to remove the added Footer.

Read More: How to Remove a Header in Excel (4 Methods)


Practice Section

For more expertise, you can practice here.


Conclusion

In the end, I like to add that I have tried to explain 3 amazing ways how to use Header and Footer in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo