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

Use Insert/Delete Rows and Columns with 3 how-to topics, including quick insertion, insertion from the Insert tab, and row or column deletion; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Quickly Insert Rows or Columns

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

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

Success Criteria

• Interface result: New rows or columns appear in the spreadsheet.
• What you can do next: You can continue entering data, adjusting formatting, or inserting more rows or columns.

Tips While Using

• Common mistake: If you do not select the target row or column first, the related floating menu may not appear.
• Environment note: For collaborative spreadsheets, keeping the network connected can help content sync normally.

2. Insert Rows or Columns from the Insert Tab

Entry: Tools → Insert → Row / Column

1. Select the row or column position where you want to insert content.
2. Tap Tools at the bottom.
3. Open the Insert tab.
4. Tap Row or Column as needed.
5. Repeat the action if you want to add more rows or columns.

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 adding data or perform other spreadsheet edits.

Tips While Using

• Common mistake: If you do not confirm whether the current selection is a row or a column, the insertion position may differ from what you expect.
• Environment note: You need to open an editable spreadsheet file first.

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 updated spreadsheet structure matches your expectation.

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 to restore the previous step.

Tips While Using

• Common mistake: If you do not verify the selected range before deleting, nearby data may be removed by mistake.
• Environment note: For important spreadsheets, confirm the content first or keep a backup in advance.