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

Use Insert/Delete Rows and Columns in WPS on iOS through 3 how-to topics, including quick insert, insert from Tools, and delete actions; all 3 topics are available without membership.

How-to Index

How-to Guide

1. Quickly Insert Rows or Columns

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

1. Select the row or column near the position where you want to insert new items.
2. Open the floating menu.
3. Tap Insert Rows/Columns.
4. 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 spreadsheet.
• What you can do next: You can continue entering data, formatting cells, or inserting more rows or columns.

Tips While Using

• Common mistake: If no target row or column is selected first, the related option may not appear.
• Environment note: You need to be in spreadsheet editing mode.

2. Insert Rows or Columns from Tools

Entry: Tools → Insert → Row / Column

1. Select the position where you want to insert a row or column.
2. Tap Tools on the bottom bar.
3. Open Insert.
4. Choose Row or Column.
5. Repeat the action if you need to keep expanding the table structure.

Success Criteria

• Interface result: A new row is inserted above the selected row, or a new column is inserted to the right of the selected column.
• What you can do next: You can continue inserting more rows or columns until the structure fits your needs.

Tips While Using

• Common mistake: If you do not confirm whether the current selection is a row or a column, the insert direction may differ from what you expect.
• Environment note: The bottom Tools panel needs to open normally.

3. Delete Rows or Columns

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

1. Select the row or column that you want to remove.
2. Open the floating menu.
3. Tap Delete Row or Delete Column as needed.
4. Check whether the spreadsheet structure has updated.

Success Criteria

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

Tips While Using

• Common mistake: If you do not confirm the selection before deleting, nearby content may be removed by mistake.
• Environment note: It is a good idea to save the file before making important structure changes.