Common questions about Insert/Delete Cell on iOS usually involve data movement, full row or column deletion, and formula changes; this section covers 3 frequent questions.
FAQ
Will inserting cells affect formula references?
- Yes. After you insert cells, related references may change as cells move.
- If the sheet already contains formulas, check the results after insertion.
- If the result is not what you expected, use Undo right away.
How do I delete an entire row or column?
- Select the target cell or related area first.
- Open Tools and go to the Home tab.
- Tap Delete Cells, then choose Entire row or Entire column.
Where does the original data go after I insert cells?
- Existing data moves in the direction that you selected.
- If you choose Shift Right, later data in the same row moves to the right.
- If you choose Shift Down, data below the current position moves downward.
Glossary
| Term | Definition |
|---|---|
| Active cell | The currently selected cell used as the reference point for insertion or deletion. |
| Shift right / Shift down | After a cell is inserted, existing data moves in the selected direction to make room for the new cell. |
| Entire row / Entire column | The command affects a full row or full column instead of only one cell. |