Custom Header and Footer (for a Workbook)

Click the Custom button in the Header area or the Custom button in the Footer area of the Workbook Page Setup dialog box (accessed by selecting Workbook Page Setup from the File menu) to display the Custom Header or the Custom Footer dialog box, respectively. Use these dialog boxes to design a customized header or footer for the document. Both dialogs contain the same controls. The Custom Footer dialog box is shown below.

Left/Center/Right. This dialog box contains three boxes: Left, Center, and Right, in which you can enter header or footer text or codes. The six buttons in the upper-left corner (described below) provide convenient access to frequently used codes and features.

Click the Font button to display the standard Font dialog box, which is used to specify the font, font size, font style, and script for the selected text. It is also used to choose certain font effects (i.e., underline, strikeout).

Click the Current Page Number button to insert the &[Page] code, which ensures that the page number is printed in the header or footer. Note that this code only prints the page number, so you may want to enter the word Page before this code.

Click the Section Name button to insert the &[Section Name] code, which will insert the name of the workbook document at the current cursor position in the header or footer.

Click the Document Name button to insert the &[Document Name] code (as shown in the example above), which will insert the document name at the current cursor position in the header or footer.

Click the Date button to insert the &[Date] code, which will insert the current date at the current cursor position in the header or footer. Note that the date format is controlled in the Windows Regional Settings dialog, accessed from the Windows Control Panel.

Click the Time button to insert the &[Time] code, which will insert the current time at the current cursor position in the header or footer. Note that the time format is controlled in the Windows Regional Settings dialog, accessed from the Windows Control Panel.

OK. After designing the custom header or footer, click the OK button to return to the Workbook Page Setup dialog box and preview the header or footer.

Cancel. Click the Cancel button to return to the Workbook Page Setup dialog box without making any changes to the currently specified header or footer.

See also, Create a Custom Header or Footer (for a Report) and Create a Custom Header or Footer (for a Spreadsheet).