Insert/Delete Cell in WPS on iOS FAQ

Last updated:July 20, 2026

When using Insert/Delete Cell in WPS on iOS, common questions usually involve cell shifting, data misalignment, and formula review; this FAQ covers 3 frequent questions.

FAQ

What is the difference between inserting cells and inserting rows or columns?

  1. Inserting cells affects only the area around the current selection.
  2. Inserting a row or column changes the structure of the entire row or column.
  3. If you only need to make space in part of a worksheet, inserting cells is usually the better choice.

Why did my data move after I deleted cells?

  1. After cells are deleted, surrounding cells automatically fill the gap by shifting left or up.
  2. If the selected range is larger than expected, the visible layout change will be more obvious.
  3. Confirm the selection before deleting. If the result is not what you want, use Undo right away.

Do I need to check formulas after inserting or deleting cells?

  1. Yes. A local structure change can affect formula references.
  2. After the action is complete, review related formula cells and confirm the results are still correct.
  3. For important worksheets, it is helpful to keep a backup or test the change in a copy first.

Glossary

TermDefinition
Insert CellAdd blank cells at the current selection and move surrounding cells in a specified direction.
Delete CellRemove cells from the current selection and let surrounding cells fill the gap automatically.
Floating menuA shortcut menu that appears after you select a cell and gives quick access to editing commands.
Shift Right / Shift DownWhen inserting cells, existing cells move right or down to make room for the new cells.
Shift Left / Shift UpWhen deleting cells, surrounding cells move left or up to fill the empty space.