Excel 2019 Bible

(singke) #1

Chapter 7: Printing Your Work


7


Adding a Header or a Footer to Your Reports
A header is information that appears at the top of each printed page. A footer is informa-
tion that appears at the bottom of each printed page. By default, new workbooks do not
have headers or footers.

You can specify headers and footers by using the Header/Footer tab of the Page Setup dia-
log box. Or, you can simplify the task by switching to Page Layout view, where you can
click the section labeled Click to Add Header or Click to Add Footer.

If you’re working in Normal view, you can choose Insert ➪ Text ➪ Header & Footer. Excel switches to Page Layout
view and activates the center section of the page header.


You can then type the information and apply any type of formatting you like. Note that
headers and footers consist of three sections: left, center, and right. For example, you can
Free download pdf