This tutorial shows you how to add headers and footers to your Excel spreadsheets to enhance their professional look. Headers and footers, containing information like page numbers and dates, are visible only when printing, in Print Preview, or Page Layout view.

• Adding Headers in Excel
• Adding Footers in Excel
• Using Preset Headers/Footers
• Creating Custom Headers/Footers
• Modifying Headers/Footers
• Closing the Header/Footer Editor
• Removing Headers/Footers
• Excel Header & Footer Tips

Adding Headers in Excel

Follow these steps:

1. Navigate to the Insert tab, locate the Text group, and click the Header & Footer button. This activates Page Layout view.
2. Type text, insert images, or use preset options in the three header boxes at the top. The central box is selected by default. Use the left and right boxes for corner placement.
3. Click outside the header area to save changes or press Esc to cancel. The header will repeat on each printed page.

Adding Footers in Excel

Adding a footer is similar:

1. On the Insert tab, click the Header & Footer button.
2. On the Design tab, select Go to Footer or scroll to the footer boxes at the page bottom.
3. Click a footer box (left, center, or right) and add text or elements. Preset footers are also available.
4. Click outside the footer area to finish.

For example, to add page numbers, select a footer box and click Page Number on the Design tab.

Using Preset Headers and Footers

Excel offers built-in options:

1. Go to Insert > Text > Header & Footer. The Design tab appears.
2. On the Design tab, click Header or Footer and choose a preset.

For instance, to add a footer with page numbers and the file name: The result:

Important Notes on Presets:

1. Dynamic Content: Presets use codes (e.g., &[Page], &[File]) that update dynamically. See the codes by clicking the header/footer box.
2. Fixed Placement: Presets insert elements into predefined boxes; you can't directly control their position.

Creating Custom Headers and Footers

Create your own headers and footers with text and images:

1. Click Header & Footer on the Insert tab.
2. Click a header or footer box and type your text. Use Design tab elements for additional content.

Example: A custom header with a logo, page numbers, file name, and date.

1. Add File Name to the center box.
2. Add Page Number to the right box (add "Page " manually for clarity).
3. Add Number of Pages to the right box (add "of" manually).
4. Insert a logo using the Picture button. The result:

Tips:

• Use Enter for new lines.
• Use && for a single ampersand.
• Use &[Page] for page numbers (with text).

Using the Page Setup Dialog Box

For chart sheets or multiple worksheets:

1. Select the sheets.
2. Go to Page Layout > Page Setup > Dialog Box Launcher.
3. Choose presets or create custom headers/footers.

Editing Headers and Footers

Edit in Page Layout view or the Page Setup dialog. Chart sheet headers/footers are editable only via the dialog.

Closing and Removing Headers/Footers

Close the header/footer editor by switching to Normal view (View tab or status bar). Remove by deleting the content in Page Layout view or selecting "(none)" in the Page Setup dialog.

Additional Tips:

• Apply to multiple sheets by selecting them first.
• Format text using the Home tab or the pop-up formatting window.
• Create different headers/footers for the first page or odd/even pages.
• Prevent header/footer resizing when scaling by unchecking Scale with Document.

This comprehensive guide provides a complete understanding of Excel headers and footers.

The above is the detailed content of Excel header and footer: how to add, change and remove. For more information, please follow other related articles on the PHP Chinese website!