How to Use WPS Sheet Tools on macOS

Use WPS Sheet Tools on macOS with 8 how-to topics, including 8 free topics and 0 membership-related topics, and jump from the index to each task directly.

How-to Index

How-to Guide

1. Adjust Row Height and Column Width

Feature entry: Select the table, then drag border lines or use related options in Table Tools.

1. Select the target table or cells in the document.
2. Drag a row border or column border to resize it manually.
3. For a more exact size, enter the value in Table Tools.
4. If needed, use an AutoFit-related option.

Success Criteria

• The row height or column width changes as expected.
• Table content is easier to read and the layout looks cleaner.

Tips While Using

• After AutoFit, the overall table width may change with content or page width.

2. Insert or Delete Rows and Columns

Feature entry: Select the table, then open Insert or Delete Cells in Table Tools.

1. Select a cell near the target position.
2. Choose to insert a row above or below.
3. Choose to insert a column to the left or right.
4. If needed, choose Delete Row, Delete Column, Cell, or Table.

Success Criteria

• A new row or column appears in the target position.
• The table structure updates after deletion.

Tips While Using

• Before deleting the whole table, confirm that the document no longer needs the original data.

3. Merge and Split Cells

Feature entry: Table Tools → Merge Cells or Split Cells.

1. Select the adjacent cells you want to merge.
2. Click Merge Cells.
3. To split a merged cell, select that cell.
4. Click Split Cells and enter the number of rows and columns.

Success Criteria

• Multiple cells become one merged area.
• A merged cell is split into the specified rows and columns.

Tips While Using

• Check the content layout before splitting so the existing format stays clear.

4. Repeat Header Rows

Feature entry: Table Tools → Repeat Header.

1. Select the row you want to use as the header, usually the first row.
2. Open Table Tools.
3. Click or enable Repeat Header.
4. Check the next page to confirm the header appears again.

Success Criteria

• The same header appears at the top of each page in a multi-page table.
• The table is easier to read in print or page view.

Tips While Using

• Make sure the header row is at the top of the table before enabling this option.

5. Allow Row Breaks Across Pages

Feature entry: Right-click the table → Table Properties → Row tab → Allow row to break across pages.

1. Select the target table and right-click it.
2. Select Table Properties.
3. Open the Row tab.
4. Enable Allow row to break across pages and confirm.

Success Criteria

• Table rows continue across page breaks normally.
• Long tables display more naturally across pages.

Tips While Using

• Preview the page layout after the change to confirm the reading order stays clear.

6. Run Calculations in a Table

Feature entry: Table Tools → Calculation drop-down menu.

1. Place the cursor in the cell where you want the result.
2. Open Table Tools.
3. Click Calculation.
4. Choose the calculation type you need, such as Sum or Average.

Success Criteria

• The result appears in the target cell.
• The result matches the current table data.

Tips While Using

• For more complex data work, WPS Spreadsheet is usually a better fit than a document table.

7. Convert a Table to Text

Feature entry: Table Tools → Convert Table to Text.

1. Select the table you want to convert.
2. Open Table Tools.
3. Click Convert Table to Text.
4. Choose a separator such as a tab, comma, or paragraph mark.
5. Confirm the conversion.

Success Criteria

• The table becomes plain text.
• The text is separated by the selected delimiter.

Tips While Using

• Choose the separator carefully so the converted content is easier to edit or copy later.

8. Use Erase and Draw Tools

Feature entry: Use the Erase button or Draw Table option in Table Tools.

1. Open Table Tools.
2. Select Erase to remove specific border lines.
3. Drag the pointer over the lines you want to remove.
4. Select Draw Table to add borders or diagonal lines in cells.
5. Exit the current tool when finished.

Success Criteria

• The selected border lines are removed, or new lines are drawn.
• The table appearance matches the intended layout.

Tips While Using

• The Erase tool changes border lines and does not directly delete text inside cells.