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

Use these 3 how-to topics to insert or delete rows and columns on iOS, and choose the matching entry from the index below to complete the task.

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 new structure.
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

• Interface result: New rows or columns appear in the target area.
• Next action available: You can continue entering data, adjusting formatting, or using Undo.

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: If the file is read-only, spreadsheet structure changes may not be available.

2. Insert rows or columns from the Insert option

Entry: Tools → Insert → Row / Column

1. Select the position where you want to insert a row or column.
2. Tap the Tools tab.
3. Select Insert.
4. Tap Row or Column as needed.
5. Repeat the command if you need 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.
• Next action available: You can continue inserting until the worksheet structure matches your needs.

Tips While Using

• Common mistake: If you do not confirm whether the current selection is row-based or column-based, the insertion position may differ from what you expect.
• Environment note: In a shared file, confirm the latest content before changing structure if others may also be editing.

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 row or column floating menu.
3. Tap Delete Row or Delete Column based on your target.
4. Check whether the remaining data is still arranged correctly.

Success Criteria

• Interface result: The selected row or column is removed from the worksheet.
• Next action available: You can continue editing the remaining cells or use Undo to restore the change.

Tips While Using

• Common mistake: If you do not confirm the selection first, you may remove a full row or column that contains data.
• Environment note: For important sheets, confirm whether the original data should be kept before deletion.