How to Insert or Delete Cells in WPS on iOS

Use this guide to complete 3 how-to topics for inserting or deleting cells in WPS on iOS, including Home-tab insertion, Home-tab deletion, and Insert-tab insertion; 3 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Insert Cells from the Home Tab

Entry path: Tools at the bottom → Home tab → Insert Cells

1. Tap Tools at the bottom.
2. Select the Home tab.
3. Tap Insert Cells.
4. Choose the insertion method you need: shift cells right, shift cells down, insert a row above, or insert a column on the left.

Success Criteria

• On-screen result: The insertion menu appears, and the spreadsheet structure updates after you choose an option.
• What you can do next: You can continue entering data, adjust formatting, or undo the action.

Tips While Using

• Common mistake: If you do not confirm the active cell first, the insertion position may not match your expectation.
• Environment note: You need to open a spreadsheet and enter editing mode before using this command.

2. Delete Cells from the Home Tab

Entry path: Tools at the bottom → Home tab → Delete Cells

1. Select the cell that you want to remove.
2. Tap Tools at the bottom.
3. Select the Home tab.
4. Tap Delete Cells.
5. Choose the deletion method: shift left, shift up, entire row, or entire column.

Success Criteria

• On-screen result: The selected cell, row, or column is removed, and nearby data shifts in the selected direction.
• What you can do next: You can continue editing nearby data or use Undo to restore the previous state.

Tips While Using

• Common mistake: Selecting an entire row or column by mistake can remove a larger area than intended.
• Environment note: Check the selected range before deleting so the current layout is not affected unexpectedly.

3. Insert Cells from the Insert Tab

Entry path: Tools at the bottom → Insert tab → Cells

1. Tap Tools at the bottom.
2. Select the Insert tab.
3. Tap Cells.
4. Choose Insert cells and shift right or Insert cells and shift down.

Success Criteria

• On-screen result: Cells are inserted in the target area, and existing data moves in the selected direction.
• What you can do next: You can continue filling in data or make additional formatting changes.

Tips While Using

• Common mistake: Running the command in the wrong selection can change the arrangement of existing data.
• Environment note: This entry is suitable for common insertion tasks. For full-row or full-column insertion, the Home tab may be more convenient.