How to Insert and Delete Rows and Columns in WPS on iOS

Last updated:July 20, 2026

Use insert and delete rows and columns with 3 how-to topics, including quick insertion, insertion from the Insert tab, and row or column deletion; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership
11. Quickly Insert Rows or ColumnsFree
22. Insert Rows or Columns from the Insert TabFree
33. Delete Rows or ColumnsFree

How-to Guide

1. Quickly Insert Rows or Columns

Entry: Row or column floating menu → Insert Rows/Columns

  1. Select the position where you want to insert rows or columns.
  2. Open the floating menu for the selected row or column.
  3. Tap Insert Rows/Columns.
  4. WPS adds rows or columns based on the number of selected rows or columns.

Success Criteria

  • Visual result: New rows or columns appear in the table.
  • Next action available: You can continue entering data, formatting cells, or inserting more rows or columns.

Tips While Using

  • Common mistake: If you do not select the target row or column first, the related option may not appear.
  • Environment note: If the file is read-only, the structure change cannot be saved.

2. Insert Rows or Columns from the Insert Tab

Entry: Insert tab → Insert Rows and Columns

  1. Select the position where you want to insert rows or columns.
  2. Tap the Insert tab at the bottom.
  3. Tap Insert Rows and Columns.
  4. Choose Insert X Rows Above, Insert X Rows Below, Insert X Columns Left, or Insert X Columns Right as needed.

Success Criteria

  • Visual result: New rows or columns appear above, below, left, or right of the selected position.
  • Next action available: You can continue filling in data or adjusting other parts of the table.

Tips While Using

  • Common mistake: Choosing the wrong direction places the new rows or columns in an unexpected position.
  • Usage tip: Before batch insertion, confirm how many rows or columns are currently selected.

3. Delete Rows or Columns

Entry: Row or column floating menu → Delete Row / Delete Column

  1. Select the row or column you want to delete.
  2. Open the floating menu.
  3. Tap Delete Row or Delete Column as needed.
  4. Check whether the updated table structure matches your expectation.

Success Criteria

  • Visual result: The selected full row or full column is removed.
  • Next action available: You can continue editing the remaining data or use Undo if needed.

Tips While Using

  • Common mistake: If you delete the wrong item, use Undo right away.
  • Usage tip: Before deleting, check whether formulas, references, or data layout will be affected.