Adding Headers and Footers in Excel

As a finishing touch, suppose you decide to add headers and footers to the worksheet, to make it clear to everyone what the data is about. 

1. Go to the Insert tab and click on Header & Footer in the Text group. The screen Header & Footer Tools will display below to assist in editing the header or footer.
2. You can also change to Page Layout view. Click the View tab, and then click Page Layout in the Workbook Views group. 
3. (Or click the middle button on the View toolbar at the bottom of the window.)
4. It is very easy to add headers and footers in Page Layout view. Instead of opening a dialog box to add a header, just click in the area at the top of the page that says add header.
5. As soon as you do, the Header & Footer Tools and the Design tab appear on the Ribbon. These have all the commands to work with headers and footers (ex. Using different headers/footers on Odd & Even pages).
6. For the header on this report, you type Tyler Family Budget, and you're done. As soon as you click the worksheet, the Header & Footer Tools and the Design tab and commands go away, until you need them again. To get them back, in Page Layout view, click in the header or footer area again.