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.
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.
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.
DIFFERENT AUTOMATIC ENTRIES WHICH CAN BE USED AS HEADER OR 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.
THREE HEADERS and three FOOTERS CAN BE ADDED SIMULTANEOUSLY in LEFT,MIDDLE AND RIGHT positions. JUST CLICK TO CHOOSE ANY OPTION AS PER THE PREVIOUS PICTURE. A COMBINATION OF DIFFERENT INPUTS ARE ALSO THERE. JUST CLICK THE BUTTON IN THE EXTREME LEFT AS IN THE PICTURE TO CHECK THE AVAILABLE OPTIONS.
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
YOU MAY LIKE
- HOW TO CONVERT TEXT TO COLUMN IN EXCEL?
- HOW TO FREEZE PANES IN EXCEL?
- how to create and arrange windows in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.