Use Insert/Delete Cell on iOS with 3 how-to topics; all 3 are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert Cells from the Home Tab | Free |
| 2 | 2. Delete Cells from the Home Tab | Free |
| 3 | 3. Insert Cells from the Insert Tab | Free |
How-to Guide
1. Insert Cells from the Home Tab
Entry path: Bottom Tools → Home tab → Insert Cells
- Tap Tools at the bottom.
- Select the Home tab.
- Tap Insert Cells.
- Choose one option: Shift cells right, Shift cells down, Insert row above, or Insert column to the left.
Success Criteria
- Interface result: The current sheet adds a new cell, row, or column based on the selected option.
- Next action: You can continue entering data or adjusting formatting.
Tips While Using
- Common mistake: Running the command before confirming the active cell may move nearby data unexpectedly.
- Environment note: Open an editable spreadsheet before starting.
2. Delete Cells from the Home Tab
Entry path: Bottom Tools → Home tab → Delete Cells
- Select the cell that you want to remove.
- Tap Tools at the bottom.
- Select the Home tab.
- Tap Delete Cells.
- Choose one option: Shift left, Shift up, Entire row, or Entire column.
Success Criteria
- Interface result: The selected area is removed and surrounding cells fill the space based on the selected option.
- Next action: You can continue editing the remaining data or use Undo.
Tips While Using
- Common mistake: Deleting without checking the selected range may affect nearby data structure.
- Environment note: Check formulas or references before deleting cells.
3. Insert Cells from the Insert Tab
Entry path: Bottom Tools → Insert tab → Cells
- Tap Tools at the bottom.
- Select the Insert tab.
- Tap Cells.
- Choose Shift cells right or Shift cells down.
Success Criteria
- Interface result: The current area is updated and existing data moves in the selected direction.
- Next action: You can continue adding new data.
Tips While Using
- Common mistake: Mixing up cell insertion in the Insert tab with full row or full column insertion in the Home tab.
- Environment note: This entry is available only in spreadsheet editing view.