Microsoft Office Tutorials and References
In Depth Information
Creating a header and footer
To apply formatting, use the small, ghostly toolbar that appears when you select text
in an edit box. Or, because the worksheet is in Page Layout view, you can click the
Home tab and use the formatting tools in the Font group as well as the editing tools
in the Clipboard group.
As in cells, if you enter more information in any of the header or footer edit boxes
than can be displayed, the information spills over into adjacent edit boxes. Yes, you
can enter too much data, actually causing text to overlap, but you’ll see it
immediately because you are working in Page Layout view.
To remove header or footer information, click the None option at the top of the
Header or Footer button menu, or simply delete the contents of the corresponding
edit boxes in Page Layout view.
Using the header/footer controls
The Page Setup dialog box contains the old-school interface for Excel’s header and footer
features. It offers all the same controls as are available on the ribbon’s Header & Footer
Tools Design tab (which appears only when a header or footer is active). Click the Page
Layout tab, click the dialog box launcher in the Page Setup group to display the Page Setup
dialog box, and then click the Header/Footer tab, as shown in Figure 11-8.
Figure 11-8 The Header/Footer tab contains controls similar to those on the Header & Footer
Tools Design tab.