How to Insert or Delete Cells in WPS on iOS

Use Insert/Delete Cell in WPS on iOS with 3 how-to topics, including 3 free topics and 0 membership-related topics; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Insert cells from the Insert tab

Entry: Bottom Insert tab → Insert Cell

1. Open a spreadsheet and go to the position where you want to insert cells, or select the target cell or range first.
2. Tap the Insert tab at the bottom.
3. Tap Insert Cell.
4. Choose Insert Cell, Shift Right or Insert Cell, Shift Down.
5. Check the result and confirm that nearby data moved in the expected direction.

Success Criteria

• On-screen result: New blank cells appear in the selected position, and surrounding cells move in the chosen direction.
• Next action available: You can continue entering data, adjusting formatting, or using Undo.

Tips While Using

• Common mistake: If the wrong range is selected, the inserted position may not match your expectation.
• Environment note: The number of inserted cells depends on the current selection size.

2. Insert cells from the floating menu

Entry: Cell floating toolbar → More Actions → Insert Cell, Shift Right/Down

1. Open a spreadsheet and go to the position where you want to insert cells, or select the target cell or range.
2. Tap the cell to open the floating editing menu.
3. Tap More Actions in the floating menu.
4. Select Insert Cell, Shift Right or Insert Cell, Shift Down.
5. Check whether the inserted cell count and shift direction match your expectation.

Success Criteria

• On-screen result: The selected number of cells is inserted, and existing data moves right or down.
• Next action available: You can continue editing content in the newly inserted area.

Tips While Using

• Common mistake: If the floating menu is not opened first, the More Actions entry may not be visible.
• Environment note: The number of inserted cells depends on the size of the selected range.

3. Delete cells from the floating menu

Entry: Cell floating toolbar → More Actions → Delete Cell, Shift Left/Up

1. Open a spreadsheet and select the cell or range you want to delete.
2. Tap the selection to open the floating editing menu.
3. Tap More Actions in the floating menu.
4. Select Delete Cell, Shift Left or Delete Cell, Shift Up.
5. Check whether nearby data has filled the gap in the selected direction.

Success Criteria

• On-screen result: The selected cells are removed, and surrounding cells move left or up to fill the space.
• Next action available: You can continue checking formulas, reviewing data order, or using Undo.

Tips While Using

• Common mistake: If you do not confirm the selection before deleting, local data may shift unexpectedly.
• Environment note: The number of deleted cells also depends on the selected range size.