HOW TO ADD HEADER AND FOOTER IN EXCEL?

 

 ** In MS Excel, a header is the section that appears at the top of every printed page, and a footer appears at the bottom of every printed page. They’re mainly used for adding consistent information such as titles, dates, page numbers, or file names to all printed pages of a worksheet.

Header

•     Location: Top margin area of a printed page.
•     Purpose: Displays information like:
•     Document title
•     Company name or logo
•     Date and time
•     Page numbers
•     File path or file name

Footer

•     Location: Bottom margin area of a printed page.
•     Purpose: Commonly used for:
•     Page numbering (e.g., “Page 1 of 5”)
•     Confidentiality notices
•     Author name
•     Revision details

How to Add Header and Footer in Excel:

    Type your text or use the Header & Footer Elements tab to insert:

•         Page Number
•         Current Date
•         Current Time
•         File Path
•         Sheet Name

    To exit, click anywhere in the worksheet or switch back to Normal View.
Notes

    Headers and footers do not appear in Normal view, only in:

•         Page Layout View
•         Print Preview
•         Printed pages

    You can have different headers/footers for the first page, odd and even pages.

    They are worksheet-specific (each sheet can have its own).