Use Insert or Delete Cells through 3 how-to topics on Android, and choose the matching entry in the index to complete each task.
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 the insertion method you need:
- Insert cells and shift active cells right
- Insert cells and shift active cells down
- Insert row above
- Insert column to the left
Success Criteria
- On-screen result: A new cell, row, or column appears in the current sheet.
- What you can do next: Continue entering data, adjusting formatting, or saving the file.
Tips While Using
- Common mistake: If you do not confirm the active cell first, the insertion position may not match your expectation.
- Environment note: In a shared file, make sure the current area is editable.
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 the deletion method:
- Shift left
- Shift up
- Entire row
- Entire column
Success Criteria
- On-screen result: The selected cell, row, or column is removed, and nearby content fills the gap in the selected direction.
- What you can do next: Continue checking formulas, reviewing layout, and saving your changes.
Tips While Using
- Common mistake: If you do not confirm the selected range first, you may remove an entire row or column by mistake.
- Environment note: If the sheet contains related formulas, review the references after deletion.
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 the insertion method:
- Insert cells and shift active cells right
- Insert cells and shift active cells down
Success Criteria
- On-screen result: New cells are inserted in the current selection based on the direction you choose.
- What you can do next: Continue adding data or switch to another editing command.
Tips While Using
- Common mistake: Mixing up the Insert tab entry with the Home tab entry may make it harder to find full row or full column insertion options.