Header and Footer in Excel Tutorial
Header and Footer
Header and Footer allow you to add some text on the top or
the bottom of the each sheet that is contained in the Excel File.
Header is used for printing the text on top of page while Footer
is used from printing on the bottom of the page. By default, both
Header and Footer are blank.
Adding Header and Footer
- You can find the Tab for Header and Footer in the Page
Setup dialog box.
Microsoft Excel has a predefined set of header and footer
for which you can choose one. You can also design your own.
- &[Page] : It shows the page number.
- &[Pages] : It shows the total count
of the pages to be printed.
- &[Date] : It shows the current date
- &[Time] : It shows the current time
- &[Path]&[File] : This option
lets you put the filename along with the complete path of the
- &[File] : This option shows the
name of the workbook.
- &[Tab] : This option shows the name
of the current sheet.
Other header and footer options
You can explore several other options in Header and Footer
by going into the option of Header and Footer in the Page Layout
view. Following are the options available.
- Different First Page: This option
allows you to set a different header and footer for the first
page than other pages.
- Different Odd & Even Pages: This
option allows you to set two different header and footer for
even and odd pages separately.
- Scale with Document: This option allows
Excel to change the font size of the text in the header and
footer to fit the content in the available space. This option is
active by default.
- Align with Page Margins: This option
set the alignment of the header and footer according to the
margins. In case of the left alignment, the header and footer
shifts towards the left margin and vice versa. This is also the