How to Insert/Delete Rows and Columns in WPS on Android

Last updated:July 20, 2026

Use this feature through 3 how-to topics, all available without membership on Android, and jump to the topic you need from the index.

How-to Index

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

How-to Guide

1. Quickly Insert Rows/Columns

Entry: Floating row/column menu → Insert Rows/Columns

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

Success Criteria

  • Interface result: New rows or columns appear in the table.
  • What you can do next: You can continue entering content, formatting cells, or adjusting the structure again.

Tips While Using

  • The number inserted depends on how many rows or columns are selected.
  • After insertion, check related formulas or references if your table contains calculations.

2. Insert Rows/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 one of the following options as needed:
    1. Insert X Rows Upward
    2. Insert X Rows Downward
    3. Insert X Columns to the Left
    4. Insert X Columns to the Right

Success Criteria

  • Interface result: New rows or columns are inserted in the selected direction.
  • What you can do next: You can continue editing the newly added area.

Tips While Using

  • Confirm the insertion direction before you proceed to reduce later adjustments.
  • X matches the number of rows or columns currently selected.

3. Delete Rows/Columns

Entry: Floating row/column menu → Delete Row / Delete Column

  1. Select the entire row or column that you want to remove.
  2. Open the floating row/column menu.
  3. Tap Delete Row or Delete Column as needed.

Success Criteria

  • Interface result: The selected row or column is removed from the table.
  • What you can do next: You can continue editing the remaining table or use Undo.

Tips While Using

  • Check the selection before deleting to avoid removing nearby content by mistake.
  • Deleting rows or columns changes table structure, so review results if formulas are involved.