PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO INSERT HEADER AND FOOTER IN EXCEL?

INTRODUCTION

Header and Footer are very important portions of a report or presentation,  when we are finalizing the reports.

First of all, let us understand what is a HEADER and what is a FOOTER.

As it is evident from the name itself, HEADER is the text or other information which is present in all the pages at the head of the page i.e. at the top of the page .

Similarly , FOOTER is the text or information which is present at the bottom portion of all the pages.

If we need some text to be present in all the pages, we make use of header or footer. There is different reserved space for them and the text can be edited only after we have changed it through the specific option of header and footer.

Let us learn how we can easily insert a header and  a footer in Excel Sheets.

 

BUTTON LOCATION FOR ADDING HEADER AND FOOTER IN EXCEL

The location of the HEADER AND FOOTER option is given below.

The HEADER AND FOOTER option is present under the INSERT TAB under TEXT section.

HEADER AND FOOTER EXCEL
HEADER AND FOOTER BUTTON IN EXCEL 2007
CREATE HEADER AND FOOTER IN EXCEL
HEADER AND FOOTER BUTTON LOCATION IN EXCEL 2013, 2016 AND 2019

STEPS TO INSERT HEADER IN EXCEL

  • STEPS:
  • Go to INSERT>TEXT and click HEADER AND FOOTER.
  • Following screen will be opened with three spaces at the header and three spaces at the bottom.
  • Enter the text in any of the three spaces as per requirement.
header and footer excel
HEADER LOCATION IN SHEET

STEPS TO INSERT FOOTER IN EXCEL

  • STEPS:
  • Go to INSERT>TEXT and click HEADER AND FOOTER.
  • Following screen will be opened with three spaces at the bottom and three spaces at the bottom.
  • Enter the text in any of the three spaces as per requirement.
insert footer excel
FOOTER LOCATION IN EXCEL

DIFFERENT AUTOMATIC ENTRIES WHICH CAN BE USED AS HEADER OR FOOTER

insert page number in header or footer
DIFFERENT OPTIONS FOR HEADER AND FOOTER

DESCRIPTION.
1. Show the current page number in the header.
2. Show the total number of pages in the header.
3.Show the current date.
4. Show the current time.
5. Show the file path of the file in which you are working with.
6. Show the file name.
7. Show the sheet name.
8. Enter the picture in the header. Excel gives the option of adding picture in the header.
9. Format the picture entered in 8 like size of the picture etc.
10. It gives you modify the different header for different pages.
11. It gives the option of scaling the size of header with page.
12. Option for giving two different kind of headers for odd and even pages.
13. Align the header with change in page margins.

INSERT HEADER EXCEL

OTHER WAYS TO REACH THIS ARTICLE

  • HEADER, FOOTER, HEADER IN EXCEL, FOOTER IN EXCEL, HOW TO REPEAT HEADING IN EXCEL, HOW TO REPEAT TEXT ON EVERY SHEET

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: