Common questions about insert or delete cells in WPS on macOS usually involve formula changes, data shifting, and membership-related actions; this section includes 4 FAQs and a glossary.
FAQ
Will formulas change after I insert or delete cells?
- Yes. After you insert or delete cells, related formula references usually adjust with the worksheet structure.
- Before making the change, review the formula area and the referenced range.
- If the result is not what you expected, use Undo right away and choose a different insert or delete option.
Why can’t I see the Delete Blank Rows option?
- First, confirm that multiple rows are selected.
- Then confirm that you are signed in with a WPS account that has the required benefits.
- If the option still does not appear, check again from the right-click menu or the ribbon delete menu.
When should I choose Shift Right or Shift Down while inserting cells?
- Choose Shift Right if you want to keep the current row continuous.
- Choose Shift Down if you want to keep the current column continuous.
- Review the surrounding layout before you apply the action so existing content stays in order.
What is the difference between deleting an entire row and deleting cells?
- Deleting an entire row removes all data in that row and is suitable for removing a full record.
- Deleting cells affects only the selected area and then fills the space based on the chosen movement option.
- If you only need to adjust part of the worksheet, deleting cells is usually the more precise choice.
Glossary
| Term | Meaning |
|---|---|
| Insert Cells | Add new cells in the current worksheet and rearrange nearby data by shifting right or down. |
| Delete Blank Rows | Remove blank rows from a multi-row selection; this is a membership-related action. |
| Delete Entire Row or Column | Remove a full row or column directly for larger structure changes. |
| Ribbon | The command area at the top of WPS where you can open row and column commands from the Home tab. |