Header And Footer in Excel

Header And Footer in Excel

Header and Footer are sections at the top and bottom of each page in Microsoft Excel that can be used to add extra information or branding to your worksheet. In a header or footer, you can add text, images, page numbers, and other information that will appear on every page of your printout.

To add a header or footer to your Excel worksheet, follow these steps:

1. Go to the "Page Layout" tab in the ribbon.
2. In the "Page Setup" group, click on the "Header & Footer" button.
3. In the "Header & Footer" tab of the Page Setup dialog box, select the type of header or footer you want to create.
4. Use the pre-built options in the "Header & Footer Elements" group, or type your own text and formatting in the header or footer section.
5. To add page numbers, click on the "Page Number" button in the "Header & Footer Elements" group and select the type of page numbers you want to use.
6. To return to the worksheet, click the "Close" button in the "Header & Footer Tools" tab.

In the header or footer, you can also use special codes, such as &[Page] or &[Date], to insert the current page number or date, respectively.

Headers and footers in Excel can be useful for adding extra information or branding to your worksheet, such as a company logo, page numbers, or the date. They can also be used to add page-level information, such as the date and time, that will appear on every page of your printout.