You can make a report more meaningful by adding headers and footers. Headers and footers supply context and key information about a report, such as its purpose and audience.
Adding a Header or Footer
Select the Header & Footer option from the Report group on the Home tab of the ribbon .
Based on view settings, ribbon groups may collapse to save space. If a group is collapsed, simply click the group label to expand the available options in your current view.
- From the Header & Footer dialog box, the Report Header option is selected by default.
- Enter Report Header text and format, as appropriate.
- Select Page Header, Page Footer, and Report Footer, to add text and format each additional options, as appropriate.
- After entering text, and formatting text accordingly, click Apply.
- Once all necessary headers and footers are added, click OK to exit.
Related Articles