Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Header and Footer in Excel

Header and Footer in Excel

Excel Header and Footer (Table of Contents)

  • What are the Header and Footer in Excel?
  • How to Create a Header in Excel?
  • How to Create Footer in Excel?
  • How to Remove Header and Footer in Excel?
  • How to Put Custom Text in Header Text?
  • How to Assign Page Number in Footer Text?

Header in Excel: It is a section of the worksheet that appears at the top of the each of the pages in the excel sheet or document. This remains constant across all the pages. It can contain information such as Page No., Date, Title or Chapter Name, etc.

Footer in Excel: It is a section of the worksheet that appears at the bottom of each of the pages in the excel sheet or document. This remains constant across all the pages. It can contain information such as Page No., Date, Title or Chapter Name, etc.

The purpose of Header and Footer in Excel

The purpose is similar to that of hard copy documents or books. The Headers and Footers in Excel help meet the standard representation format of the documents and/or worksheets. They add a sense of organization to the soft documents and/or worksheets.

Header & Footer Tools in Excel

Header & Footer

As we can see in the screenshot above, there are 4 sections under Header & Footer Tools namely Header & Footer, Header & Footer Elements, Navigation, and Options. This particular Toolbox appears after clicking Insert-> Header & Footer.

  1. Header & Footer – This shows a list of the quick options to be used as a header or footer.
  2. Header & Footer Elements – This has a set of options for the text to be used as header or footer such Page Number, File Name, Number of Pages, etc.
  3. Navigation – It has 2 options i.e. Go to Header and Go to Footer which navigates the cursor to the respective area.
  4. Options – It has 2 options related to conditionally put up of the header and footer i.e. Different on the first page and Different on Odd & Even page. The other 2 options are regarding the formatting of the excel page. One is to scale the header/footer with the document. The other is to align the header/footer with page margins.

How to Create a Header in Excel?

  • Click the worksheet where you want to add or change the header then, Go to Insert tab -> Text group -> Header & Footer.

Header Exaample 1

  • Clicking on it would open a new window as shown below.

Header Exaample 1-1

  • As shown in the screenshot given below, Header & Footer Tools has Design Tab which contains various text options to put as the header. The default one is an empty text box wherein you can enter a free text e.g. ‘This is the header text’. The other options are Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, Sheet Name, Picture, etc.

Header Example 1-2

  1. Click the worksheet where you want to add or change the header then, Go to Insert tab -> Text group -> Header & Footer.

Footer Example 1

  • Clicking on it would open a new window as shown. As shown in the screenshot given below, Header & Footer Tools has Design Tab which contains various text options to put as the header. The default one is an empty text box wherein you can enter a free text e.g. ‘This is the Footer text’. The other options are Page Number, Number of Pages, Current Date, Current Time, File Path, File Name, Sheet Name, Picture, etc.

Footer Text

  1. As shown, launch Page Setup dialog box from the Page Setup box under Page Layout menu.

Remove Header & Footer 1

  • Goto Header/Footer section.

Remove Header & Footer 1-1

  • As shown, select ‘none’ for Header and/or Footer so to remove the respective feature.

Remove Header & Footer 1-2

How to Put Custom Text in Excel Header?

In the following example, ‘This is the header text’ is the custom text entered in the Header box. The same will reflect on all the pages in the worksheet.

The Header Text Editor can be closed by pressing Escape key on the keyboard.

Header Text

How to Assign Page Number in Excel Footer Text?

As shown in the figure, a page number can be entered as the footer text. Refer to the screenshot below to understand the same.

In the following example, ‘Page [&page] Of [&page]’ is the text entered in the Footer box. Here, &page is a dynamic parameter and evaluated to the page number. The first parameter is the current page number and the second is the total number of pages. The same will reflect on all the pages in the worksheet.

To give page Numbers to a sheet, Click on a sheet, then go to Footer and Click on Design tab under Header & Footer Tools, and then Select Page Number.

Page Number

After Selecting Page Numbers it will Displays as &[Page]Of as shown in below screenshot.

Footer Text Page Number

To show page numbers with Total Numbers of Pages, click on Number of pages under the design tab in the Header & Footer tool.

Number of Pages

After Selecting Number of Pages, it will add &[Pages] with &[Page]Of.

Footer Text Page Number 1

Then it shows Page Number with Number of Pages.

Number of Pages 1

The Footer Text Editor can be closed by pressing Escape key on the keyboard.

Note: In addition to the above-explained examples, the other options for Header/Footer text that are made available by MS Excel are Date, Time, File Name, Sheet Name, etc.

Things to Remember About Header and Footer in Excel

  1. Headers and footers in Excel help meet the standard representation format of the documents or worksheets.
  2. They add a sense of organization to the soft documents.
  3. Excel offers a variety of options to be put up as Header/Footer text such as Date, Time, Sheet Name, File Name, Page Number, Custom Text, etc.

Recommended Articles

This has been a guide to Header and Footer in Excel. Here we discuss how to create and remove Header and Footer in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • Circular Reference in Excel
  • Filter Shortcut in Excel
  • Insert Row Shortcut in Excel
  • Custom Number Format in Excel

The post Header and Footer in Excel appeared first on Learn Investment Banking: Financial Modeling Training Courses Online.



This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Header and Footer in Excel

×

Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription

×