WPS Insert or Delete Cells on Android FAQ

Last updated:July 20, 2026

When using Insert/Delete Cell, common questions usually involve the difference from row or column insertion, data shifting, and formula checks; this FAQ includes 3 common questions and a 3-term glossary.

FAQ

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

  1. Inserting cells creates space only within the current selection and shifts surrounding cells in a chosen direction.
  2. Inserting a whole row or column changes the structure of the entire sheet.
  3. If you only need a local adjustment, inserting cells is usually the more suitable option.

Will deleting cells cause data misalignment?

  1. Yes. After cells are deleted, surrounding cells fill the gap by shifting left or up.
  2. Confirm the selected range before deleting so that unrelated data is not affected.
  3. After deletion, review nearby data, header alignment, and formula results.

Why should I check formulas after inserting cells?

  1. Changes in cell position may affect formula reference ranges.
  2. If the sheet contains sums, lookups, or linked references, review the results after the insertion.
  3. If the result looks wrong, undo the action first and then choose a more suitable insertion method.

Glossary

TermDefinition
Insert Cell, Shift RightInserts a new blank cell at the current position and moves later cells in the same row to the right.
Insert Cell, Shift DownInserts a new blank cell at the current position and moves related cells below downward.
Floating toolbarA quick action menu that appears near the editing area after you select a cell and can be used to access more editing commands.