Excel Optimize

Problem: You are printing a lengthy report. You want the pages to be numbered.

Strategy: The Header and Footer options are controlled on the third tab of the Page Setup dialog box. There are a variety of formats that can be specified on this tab.

1. Select Page Setup from the File menu. The dialog box offers four tabs.
2. Select the third tab, called Header/Footer. There are a number of standard options in the Footer dropdown, as shown in Fig. 39.
3. Select the options called Page 1 of ?. This option will print a footer, such as Page 1 of 2, at the bottom center of each page.

Alternate Solution: It is possible to design a custom footer by selecting the Custom Footer… button. In a custom footer, you can build a footer for the left, center, and right sides of the page.

1. Select the Custom Footer… button.
2. Tab to the right section: Text box.
3. Type the word “Page” followed by a space.
4. Click the Page # icon (Fig. 40).
5. Type a space, followed by the word “of”, followed by another space.
6. Click the Total Pages icon (Fig. 41).

Result: The custom footer text appears on the right side of the page, as shown in Fig. 42.
Additional Information: There are also left, center, and right headers that can be customized like
the footers.
Gotcha: Sometimes the footer text will crash into the data from the report, as shown in Fig. 43. If
you have adjusted the lower margin to 0.5”, you should adjust the footer margin to 0.25” to prevent this condition.
Summary: You can customize the header and footer to contain a page number, total number of
printed pages, the fi le name, or any custom text that you like. There are left, center, and right headers.