Use Header and Footer with 3 how-to topics, including inserting headers and footers, using preset headers and footers, and customizing headers and footers. Choose a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert Header and Footer | Free |
| 2 | 2. Use Preset Header and Footer | Free |
| 3 | 3. Customize Header and Footer | Free |
How-to Guide
1. Insert Header and Footer
Entry path:
- Page tab → Header and Footer
- Print Preview → Header and Footer
- Open the spreadsheet file that you want to print.
- Click Header and Footer on the Page tab.
- Or open Print Preview first, then click Header and Footer.
- After the editing mode opens, you can start inserting or changing content.
Success Criteria
- Interface result: Header and Footer editing mode is open.
- Next action available: You can continue with preset styles or custom content.
Tips While Using
- The standard editing view does not show the final print result clearly, so it is recommended to check in Print Preview.
2. Use Preset Header and Footer
Entry path: Header and Footer toolbar
- Enter Header and Footer editing mode first.
- Click the Header or Footer drop-down button.
- Select a preset style such as page number, date, or file name.
- Turn on Different Odd and Even Pages or Different First Page if needed.
- Confirm that the preset content appears in the target area.
Success Criteria
- Interface result: The selected preset content appears in the header or footer area.
- Next action available: You can continue adjusting page settings and review the result in Print Preview.
Tips While Using
- Before choosing a preset, confirm what information should appear on the printed page to avoid duplicate content.
3. Customize Header and Footer
Entry path: Header and Footer editing area
- Enter Header and Footer editing mode.
- Double-click the header or footer preview area, or click Custom Header/Footer.
- Choose the left, center, or right section that you want to edit.
- Enter custom text.
- Insert pictures, page numbers, time, or total page count as needed.
Success Criteria
- Interface result: The custom content appears in the selected section.
- Next action available: You can save the file or open Print Preview to check the result.
Tips While Using
- When inserting multiple elements, plan the left, center, and right sections first so the printed page does not look crowded.