How to Use WPS Print Titles on Windows

Last updated:July 17, 2026

Use Print Titles through 3 how-to topics: set top title rows, set left title columns, and set multiple title rows or columns; use the index below to jump to each task.

How-to Index

No.TopicMembership Requirement
11. Set top title rowsFree
22. Set left title columnsFree
33. Set multiple title rows or columnsFree

How-to Guide

1. Set top title rows

Entry: Page tab → Print Titles

  1. Open the spreadsheet you want to print.
  2. Click the Page tab.
  3. Click Print Titles.
  4. In the Page Setup dialog box, find Rows to repeat at top.
  5. Click the selection button and choose the row or rows that should repeat at the top of every printed page.
  6. Click OK to apply the setting.

Success Criteria

  • Interface result: The selected row reference appears in the Rows to repeat at top box.
  • Next action: In print preview, the selected title row appears at the top of each printed page.

Tips While Using

  • Common mistake: Selecting an incomplete header row can make printed labels incomplete.
  • Environment note: If no printer or printer driver is available on the device, some print-related previews may be limited.

2. Set left title columns

Entry: Page tab → Print Titles

  1. Open the spreadsheet you want to print.
  2. Click the Page tab.
  3. Click Print Titles.
  4. In the Page Setup dialog box, find Columns to repeat at left.
  5. Click the selection button and choose the column or columns that should repeat on the left side of every printed page.
  6. Click OK to save the setting.

Success Criteria

  • Interface result: The selected column reference appears in the Columns to repeat at left box.
  • Next action: In print preview, the left-side label column remains visible across pages.

Tips While Using

  • Common mistake: Selecting a data column instead of a label column can produce unexpected repeated content.
  • Environment note: Left title columns are especially useful for wide tables that need category labels across pages.

3. Set multiple title rows or columns

Entry: Page tab → Print Titles

  1. Open the spreadsheet and go to the Page tab.
  2. Click Print Titles to open Page Setup.
  3. In Rows to repeat at top, select a multi-row range such as $1:$3.
  4. In Columns to repeat at left, select a multi-column range such as $A:$B.
  5. Check whether the references match your print layout needs.
  6. Click OK to finish.

Success Criteria

  • Interface result: Both top-row and left-column reference boxes show the selected ranges.
  • Next action: In print preview, repeated multi-row headers and multi-column labels appear together.

Tips While Using

  • Common mistake: Selecting a range that is too large can reduce the usable data area on each printed page.
  • Environment note: Print Titles affects printed output and print preview, not the worksheet editing view.