Common questions about Print Titles usually focus on repeated display, clearing settings, and saved behavior; this section covers 3 frequent questions.
FAQ
Why do my title rows not repeat on every printed page?
- Open the Page tab and click Print Titles.
- Check whether the correct row reference appears in Rows to repeat at top.
- Open print preview and confirm that the worksheet actually spans multiple printed pages.
- If the issue remains, check whether the reference was cleared or changed before clicking OK.
How do I remove Print Titles settings?
- Click Print Titles on the Page tab.
- Clear the references in Rows to repeat at top or Columns to repeat at left.
- Click OK to save the change.
- Open print preview again to confirm that repeated titles are no longer applied.
Does Print Titles affect worksheet editing?
- Print Titles only affects print output and print preview.
- When you return to the worksheet, cell content and layout remain unchanged.
- If you need a different display result, adjust print settings and worksheet content separately.
Glossary
| Term | Definition |
|---|---|
| Print Titles | A worksheet print setting that repeats selected rows or columns on every printed page. |
| Rows to repeat at top | Rows that appear at the top of each printed page, usually used for table headers. |
| Columns to repeat at left | Columns that appear at the left side of each printed page, usually used for row labels or categories. |