WPS Sheet Tools on macOS FAQ

Last updated:July 15, 2026

When using WPS Sheet Tools on macOS, common questions usually involve display, page breaks, repeated headers, and conversion tasks; this FAQ covers 5 frequent questions.

FAQ

What can I do if table content is not fully displayed?

  1. Select the table.
  2. Open Table Tools.
  3. Use an AutoFit-related option, such as fitting the table to its content.
  4. If needed, adjust row height or column width manually.

What can I do if a table looks awkward after it crosses pages?

  1. Right-click the table and open Table Properties.
  2. Open the Row tab.
  3. Enable Allow row to break across pages.
  4. Check the page layout again.

What can I do if a blank page appears after the table?

  1. Place the cursor in the empty paragraph after the table.
  2. Open Paragraph settings.
  3. Reduce line spacing or related paragraph spacing if needed.
  4. Check whether the blank page disappears.

How do I show the same header on every page?

  1. Select the row used as the header.
  2. Open Table Tools.
  3. Click Repeat Header.
  4. Go to the next page and confirm the header repeats.

How do I turn table content into plain text?

  1. Select the target table.
  2. Open Table Tools.
  3. Click Convert Table to Text.
  4. Choose a suitable separator and confirm.

Glossary

TermDefinition
Repeat HeaderA feature that shows the table header again at the top of later pages when a table spans multiple pages.
Row Break Across PagesA setting that allows a table row to continue across a page break to reduce layout issues in long tables.
Convert Table to TextA feature that changes a table into plain text and separates content with a selected delimiter.
Merge CellsA command that combines adjacent cells into one larger cell area.
EraseA tool that removes selected table border lines to adjust structure or appearance.