This FAQ covers 3 common question types about insertion quantity, recovery after deletion, and formula impact when editing table structure on Android.
FAQ
Can I insert multiple rows or columns at one time?
- Yes. First, select the same number of rows or columns as the amount you want to insert.
- Then run the insert action.
- WPS inserts the same number of rows or columns as your current selection.
Can I recover deleted rows or columns?
- Yes. If you delete something by mistake, use Undo right away.
- If you have not made too many follow-up edits, you can usually return to the previous state.
- Before deleting important content, confirm the selection or save the document first.
Why should I check formulas after inserting or deleting rows and columns?
- Structural changes can affect existing reference ranges.
- If the table contains sums, statistics, or linked references, results may change with the new structure.
- After inserting or deleting rows or columns, review key calculation cells.
Glossary
| Term | Definition |
|---|---|
| Floating menu | A shortcut menu that appears after you select rows, columns, or cells in a table. |
| Insert Rows and Columns | An action that adds entire rows or columns above, below, left, or right of the current selection. |
| Delete Row/Column | An action that removes the selected entire row or entire column from the table structure. |