How to Use WPS Sheet Tools on Windows

Use Sheet Tools through 8 task topics in WPS Writer, and choose the matching item from the index to complete each table task.

How-to Index

How-to Guide

1. Select table objects

Entry: Move the pointer to the target area of the table and select the object you need.

1. Move the pointer to the left side of a cell, and click when it changes to a black arrow to select one cell.
2. Drag from the starting cell to the ending cell to select a continuous range.
3. Hold Ctrl and click different areas to select non-contiguous ranges.
4. Move the pointer to the left side of a row or the top of a column, then click to select the whole row or column.
5. Click the cross icon at the upper-left corner of the table to select the entire table.

Success Criteria

• The target cell, row, column, range, or full table is selected correctly.
• Table commands can be applied to the selected object.

Tips While Using

• When you use Ctrl+A, make sure the cursor focus is inside the table.
• Non-contiguous selection is useful for partial formatting changes.

2. Adjust row height and column width

Entry: Select the table and drag border lines, or use settings in the Table Tools tab.

1. Select the cells, rows, columns, or table that you want to adjust.
2. Drag row borders or column borders for manual adjustment.
3. If exact sizing is needed, enter values in Table Tools.
4. If automatic sizing is needed, use AutoFit based on content or window width.

Success Criteria

• Row height or column width changes as expected.
• Table content is displayed more clearly and the layout is more even.

Tips While Using

• AutoFit is useful for quick cleanup when a table contains a lot of content.
• Exact values are useful for formal documents with a consistent layout.

3. Insert or delete rows and columns

Entry: Select the table, then open Insert or Delete in the Table Tools tab.

1. Select a cell near the target position.
2. Choose Insert Row Above or Insert Row Below to add a row.
3. Choose Insert Column Left or Insert Column Right to add a column.
4. To remove content, select the target and use Delete Row, Delete Column, Cell, or Table.

Success Criteria

• The number of rows or columns changes as planned.
• The table remains editable after the change.

Tips While Using

• Check whether the original data still needs to be kept before deleting a full table.
• Confirm the target position before inserting multiple rows or columns.

4. Merge and split cells

Entry: Use Merge Cells or Split Cells in the Table Tools tab.

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

Success Criteria

• Cells are merged or split according to your settings.
• The header or layout structure better matches the document design.

Tips While Using

• Confirm the content layout before merging to reduce rework later.
• After splitting, you can still adjust row height and column width for better display.

5. Repeat header rows

Entry: Use Repeat Header Rows in the Table Tools tab.

1. Select the row or rows that should act as the table header, usually the first row.
2. Open the Table Tools tab.
3. Click Repeat Header Rows.
4. Preview the multi-page result and confirm that the header appears at the top of each page.

Success Criteria

• The same header appears at the top of each page when the table spans multiple pages.
• The table is easier to read and print.

Tips While Using

• Header rows are usually placed at the beginning of the table.
• This setting is especially useful for long tables and print layouts.

6. Allow rows to break across pages

Entry: Open Table Properties from the right-click menu, then go to the Row tab.

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

Success Criteria

• Table rows can continue normally at page breaks.
• Long tables display more smoothly across multiple pages.

Tips While Using

• For content that should stay together in one row, decide whether to enable this based on layout needs.
• Check page preview after changing the setting.

7. Sort and calculate in tables

Entry: Use Sort, Calculation, or Formula in Table Tools.

1. Select the table content that you want to sort.
2. Click Sort and set the sort basis and order.
3. If you need a calculation, place the cursor in the result cell.
4. Use Calculation for sum or average, or use Formula for a custom formula.

Success Criteria

• Table content is reordered according to the selected sort settings.
• The result cell displays the calculation result.

Tips While Using

• Check whether the table includes a header before sorting so the header is not sorted with the data.
• For more complex formulas, confirm the reference range before applying the formula.

8. Convert tables to text, erase borders, and draw diagonal lines

Entry: Use Convert to Text, Eraser, or Draw Table in Table Tools.

1. Select the target table, use Convert to Text, and choose a separator to turn the table into plain text.
2. Click Eraser and drag across borders that you want to remove.
3. Click Draw Table to add diagonal lines or extra borders inside cells.
4. Press Esc or click the tool again to exit the current mode.

Success Criteria

• The table is converted to text when needed.
• Selected borders are erased or diagonal lines are added successfully.

Tips While Using

• The Eraser removes border lines, not the text content inside cells.
• Choose the separator carefully before converting a table to text.