Common questions about inserting or deleting cells in WPS on iOS usually involve formula references, full-row or full-column deletion, and how shifted data behaves; this FAQ includes 3 common questions and 3 glossary terms.
FAQ
Will inserting cells affect formula references?
- After inserting cells, check the formulas in the affected area.
- Pay special attention to nearby relative references around the insertion point.
- If the result is not what you expected, use Undo and choose a different insertion method.
How do I delete an entire row or column?
- Select the target cell or the related area first.
- Tap Tools at the bottom and open the Home tab.
- Tap Delete Cells, then choose Entire Row or Entire Column.
Where does the existing data go after I insert cells?
- If you choose shift right, the data on the right side of the current row moves to the right.
- If you choose shift down, the data below the current column moves downward.
- After the insertion, review nearby cells to confirm that the data moved to the expected position.
Glossary
| Term | Definition |
|---|---|
| Active cell | The current cell used as the reference point for editing. Insert and delete actions are usually based on this position. |
| Shift right / Shift down | After a cell is inserted, existing data moves horizontally or vertically to make room for the new cell. |
| Entire row / Entire column | A command that affects a full row or full column instead of only one cell. |