Feature Summary
The Print Titles feature is used to repeat specified rows or columns as titles on each printed page, making it easier to identify the meaning of each column or row in multi-page documents.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Setting Print Titles
Feature Entry
"Page" tab → "Print Titles"
- Click the Page tab
- Click the Print Titles button
- In the pop-up Page Setup dialog, set the "Rows to repeat at top" 、 "Columns to repeat at left" and "Columns to repeat at bottom"
- Click the selection icon for "Rows to repeat at top" 、 "Columns to repeat at left" and "Columns to repeat at bottom" respectively to select the rows/columns to repeat
- Multiple rows/columns can be selected (e.g., $1:$3) / ($A:$B)
- Click OK to apply
FAQ
Q1: What should I do if the title rows do not repeat on every page?
- Solution: Check whether the Print Titles settings are correct and ensure the correct row numbers are selected.
Q2: How do I cancel Print Titles?
- Solution: Clear the references for the title rows/columns in the Print Titles settings and click OK.
Notes
- Print Titles only appear when printing and do not affect the worksheet view
- Print Titles settings are saved with the document