When using Insert/Delete Rows and Columns, common questions usually involve where to find the entry, how insertion quantity works, and how to recover from accidental deletion; this FAQ includes 4 common questions and a glossary.
FAQ
Why can’t I find the Insert Row/Column entry?
- Confirm that you opened a spreadsheet file and that the selected area is editable.
- Select the target row or column position and check whether the row/column floating menu appears.
- If the floating menu does not appear, tap Tools and open the Insert tab to find Row or Column.
Can I insert multiple rows or columns at one time?
- Select multiple rows or columns first.
- Then use the Insert Row/Column feature.
- The number inserted follows the number of selected rows or columns.
Can I recover rows or columns after deleting them?
- Avoid making too many extra edits right after deletion.
- Use Undo immediately to reverse the previous action.
- Confirm that the original data and structure are restored.
Where are the insert row and insert column positions?
- When you use Tools → Insert, tapping Row inserts above the selected row.
- Tapping Column inserts to the right of the selected column.
- Confirm the current selection before you insert anything so the new content appears in the intended area.
Glossary
| Term | Definition |
|---|---|
| Floating menu | A shortcut menu that appears near the selected row or column and lets you quickly insert or delete structure items. |
| Insert tab | A function group inside Tools that lets you insert rows, columns, and other structural elements. |
| Collaborative spreadsheet | A spreadsheet that can be viewed or edited by multiple people. On mobile devices, a network connection is recommended for smoother syncing. |
| Undo | A command that reverses the most recent edit. It is often the fastest way to recover from accidental row or column deletion. |