Insert/Delete Rows and Columns in WPS on iOS FAQ

This FAQ covers 4 common questions about finding the entry, understanding insertion direction, recovering from deletion, and checking whether membership is required.

FAQ

Why can't I find the Insert Row/Column option?

1. Make sure the current file is an editable spreadsheet instead of a preview-only file.
2. Tap or select the target row, column, or cell in the sheet.
3. Check whether the floating menu appears, or open Tools and look for Insert.
4. If the option still does not appear, update WPS Office and reopen the file.

Where will the inserted row or column appear?

1. When you use Tools → Insert, a row is inserted above the selected row and a column is inserted to the right of the selected column.
2. Confirm the current selection before you insert.
3. If the result is not what you expected, use Undo and choose the position again.

Can I recover a deleted row or column?

1. If the deletion was just completed, use Undo first.
2. After recovery, confirm the exact range you want to remove.
3. For important spreadsheets, keep a backup copy before deleting structure.

Does this feature require WPS Premium?

1. This feature can be used directly.
2. Everyday row insertion, column insertion, row deletion, and column deletion are not membership-restricted items.
3. If you need broader office benefits, choose a membership plan based on your own usage needs.

Glossary