When using Insert/Delete Cell in WPS, common questions usually involve formula changes, membership-related options, and undo steps; this FAQ includes 4 common questions and a glossary.
FAQ
Will inserting or deleting cells affect formula references?
- Yes. After you insert or delete cells, related formula references can adjust with the worksheet structure.
- Check important summary areas and calculation results after the change.
- If the result is not what you expected, press Ctrl + Z and try the action again.
Why can’t I use Delete Blank Rows?
- First, make sure you are opening the correct delete menu for this feature.
- Delete Blank Rows is a membership-related option, so it may be unavailable without the required plan.
- If you need it, open the subscription page and review the available plan options.
What should I do if I deleted the wrong cell, row, or column?
- If you notice the issue right away, press Ctrl + Z to undo it.
- Check whether the worksheet has returned to the previous state.
- If several actions have already been completed, review the sheet as soon as possible and undo step by step if needed.
Why did my data move in an unexpected way after insertion?
- Check whether you selected Shift Right, Shift Down, or an entire row or column insertion option.
- Confirm that the selected range was correct before the action.
- If the result is not correct, undo the action and choose a more suitable insert method.
Glossary
| Term | Definition |
|---|---|
| Insert Cells | Add one or more cells to the current worksheet and move nearby data according to the selected rule. |
| Delete Blank Rows | Remove blank rows from a selected range to clean up worksheet structure. |
| Entire Row / Entire Column | Insert or delete a full row or full column instead of changing only one cell. |
| Cell Shift | The way nearby cells move left, right, up, or down after an insert or delete action. |