Common questions about inserting or deleting cells usually involve data movement, row or column deletion, and formula changes; this FAQ includes 3 common questions and a glossary.
FAQ
Will inserting cells affect formula references?
- Check whether there are formulas near the area where you plan to insert cells.
- After inserting cells, review the related formula results.
- If the result is different from what you expected, check the reference range again and adjust it as needed.
How do I delete an entire row or column?
- Select the target cell or the 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?
- Check whether you selected the option to shift cells right or shift cells down.
- After insertion, the original data moves to the adjacent position in that direction.
- If you want to restore the previous layout, adjust the affected area again right away.
Glossary
| Term | Definition |
|---|---|
| Active cell | The cell that is currently selected or being edited. Insert and delete actions usually use it as the reference point. |
| Shift right | After insertion or deletion, related cell content is rearranged toward the right. |
| Entire column | An insertion or deletion action applied to a full column rather than a single cell. |