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

Use Insert/Delete Rows and Columns in WPS on Android with 3 how-to topics, including 3 free topics and 0 membership-related topics; choose a topic from the index to complete worksheet structure changes quickly.

How-to Index

How-to Guide

1. Quickly insert rows or columns

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

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

Success Criteria

• On-screen result: New rows or columns appear near the selected position.
• 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: The number of inserted rows or columns depends on the current selection size.

2. Insert rows or columns from the Insert tab

Entry point: Tools → Insert → Row / Column

1. Select the position where you want to insert rows or columns in the worksheet.
2. Tap Tools at the bottom.
3. Open the Insert tab.
4. Select Row or Column.
5. If you need to keep expanding the worksheet, repeat the same action.

Success Criteria

• On-screen 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 multiple rows or columns.

Tips While Using

• Common mistake: If you do not confirm whether a row or a column is selected, the insertion position may differ from what you expect.
• Environment note: Repeated taps keep adding rows or columns, so it is helpful to confirm the target area first.

3. Delete rows or columns

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

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

Success Criteria

• On-screen result: The selected row or column is removed from the worksheet.
• What you can do next: You can continue editing the remaining data or use Undo to restore the change.

Tips While Using

• Common mistake: If you do not confirm the selection before deletion, nearby data may be removed by mistake.
• Environment note: For important worksheets, confirm the content before deleting rows or columns.