Insert/Delete Cell in WPS on macOS FAQ

Last updated:July 20, 2026

Common questions about Insert/Delete Cell usually involve data misalignment, command entry differences, batch actions, and formula impact; this section covers 4 frequent questions.

FAQ

What should I do if data becomes misaligned after I insert cells?

  1. Press Command + Z immediately to undo the last action.
  2. Select the target cell range again.
  3. Choose the correct option to shift cells right or down.
  4. Review nearby data to confirm the layout is correct.

Why do I not see the expected insert-cell options?

  1. Make sure you selected cells instead of a full row or full column.
  2. If needed, reselect a specific cell range.
  3. Open the right-click menu or the Insert tab again and check the available commands.

Can I insert multiple cells at one time?

  1. Select multiple continuous cells first.
  2. Run the insert command.
  3. Choose the shift direction you need.
  4. Confirm that the inserted area matches the original selection size.

Will inserting or deleting cells affect formulas?

  1. Yes, it may affect related references in some spreadsheets.
  2. After the insert or delete action, review formulas in the affected area.
  3. If the result is not what you want, undo the action and try a different edit path.

Glossary

TermDefinition
Shift cells rightInsert a new cell at the current position and move existing content to the right.
Shift cells downInsert a new cell at the current position and move existing content downward.
Shift right-side cells leftDelete the current cell and move the cell on the right into the empty position.
Shift lower cells upDelete the current cell and move the cell below upward to fill the gap.