Headers and Footers in Microsoft Excel

In this article, you’ll get to know about Headers and Footers and how to insert them in your spreadsheets in Microsoft Excel.

Headers are added to the top of the page and Footers to the bottom. These are kinds of extras such as date, page numbers, or the name of the file, etc to the worksheet.

How to add headers and footers to a worksheet?

  • First, select the worksheet to which you want to add these.
  • Then go to the Insert tab, under the Text group which can be found at the rightmost corner of the menu.
  • Now select the Header & Footer option in the Text group.
Headers and Footers in Excel
Headers and Footers in Excel
  • Now you can view the Header and Footer space where you can add the data you want.
Headers and Footers in Excel

Excel also allows you to customize the Header and Footer by providing the Design tab.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...