WPS Insert and Delete Rows and Columns on iOS FAQ

Last updated:July 20, 2026

Common questions about insert and delete rows and columns focus on batch insertion, undo recovery, and formula impact; this FAQ includes 4 common questions and 4 glossary terms.

FAQ

Can I insert multiple rows or columns at one time?

  1. Yes. First select the same number of rows or columns as the amount you want to add.
  2. Then run Insert Rows/Columns or Insert Rows and Columns.
  3. WPS inserts the same number of rows or columns as your current selection.

Can I undo a deleted row or column?

  1. Yes. If you delete the wrong row or column, use Undo immediately.
  2. If you have already made more edits, review the current table carefully.
  3. Confirm that the data and structure are restored before saving again.

Why is the number of inserted rows or columns different from what I expected?

  1. Check how many rows or columns were selected before you inserted them.
  2. The number inserted depends on the current selection.
  3. If needed, undo the change, select the correct range, and try again.

Will inserting or deleting rows and columns affect formulas?

  1. It may affect formulas that reference the related area.
  2. After inserting or deleting rows or columns, review sums, references, and calculation results.
  3. If needed, update the formula range manually.

Glossary

TermDefinition
Floating menuA quick-action menu that appears after you select a row or column in a table, letting you run insert or delete commands directly.
Insert rows and columnsThe action of adding full rows or full columns to the current table structure, including directional insertion options.
Delete rowThe action of removing the selected full row from the table.
Delete columnThe action of removing the selected full column from the table.