Insert/Delete Rows and Columns in WPS on iOS FAQ

When using Insert/Delete Rows and Columns in WPS on iOS, common questions usually involve where to find the command, why insert counts change, and how to recover from deletion; this FAQ covers 4 common questions.

FAQ

Why can’t I find the Insert Rows/Columns option?

1. Make sure you opened a spreadsheet file instead of a document or presentation file.
2. Select a specific row or column so the floating menu can appear.
3. If the option still does not appear, tap Tools and look for the insert command under Insert.

Why does the number of inserted rows or columns change?

1. Check how many rows or columns are currently selected.
2. In quick insert mode, the number of new rows or columns follows the current selection size.
3. If you only want one new row or one new column, select only one row or one column before inserting.

Can I recover a deleted row or column?

1. Avoid making many more edits immediately after deletion.
2. Use Undo right away to restore the removed content.
3. If the file has already been saved and synced, check whether a history version or backup is available.

How can I edit spreadsheet structure more accurately on iPhone?

1. Zoom in on the spreadsheet view to reduce accidental selection of nearby rows or columns.
2. Confirm the current selection before inserting or deleting.
3. For important files, save a copy before making structure changes.

Glossary