Common questions about Print Titles usually focus on repeated display results, clearing settings, and checking print output; this FAQ includes 3 common questions and a glossary.
FAQ
Why do title rows not repeat on every printed page?
- Open Print Titles from the Page tab.
- Check whether Rows to repeat at top contains the correct row reference.
- Confirm that you are printing the same worksheet where the setting was applied.
- Open Print Preview to verify the result.
How do I clear Print Titles after setting them?
- Click Print Titles on the Page tab.
- Clear the references in Rows to repeat at top and Columns to repeat at left.
- Click OK to save the change.
- Preview the print result again to confirm that titles no longer repeat.
Does Print Titles affect the normal worksheet view?
- Print Titles only takes effect during printing.
- It does not change the normal worksheet view while editing.
- You can continue editing, saving, and viewing worksheet data as usual.
Glossary
| Term | Definition |
|---|---|
| Print Titles | A print setting that repeats selected title rows or title columns on each printed worksheet page. |
| Rows to repeat at top | Rows that appear at the top of every printed page, usually used for table headers. |
| Columns to repeat at left | Columns that appear at the left side of every printed page, usually used for category fields. |