Guide to Using Insert/Delete Rows and Columns Feature in AirSheet

Feature Summary

Insert new rows or columns at a specified position, or completely delete selected rows or columns along with the data they contain.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction

Steps

Right-Click Menu

Feature Entry
Select row number/column header → Right-click → Add rows/columns

1. Click a row number to select the entire row, or click a column header to select the entire column.
2. Right-click on the selected row number/column header, and choose from the pop-up menu:

• "Add rows above" / "Add rows below": Add a specified number of new rows above or below the selected row.
• "Add columns to the left" / "Add columns to the right": Add a specified number of new columns to the left or right of the selected column.
• "Delete rows" / "Delete columns": Directly delete the selected rows/columns.

3.Select multiple rows/columns to delete them in batch.

Menu Bar

Feature Entry
"Insert" tab → "Rows & Columns" button

1. Click the target location in the sheet (e.g., the reference position for inserting rows/columns).
2. Switch to the "Insert" tab.
3. Click the "Rows & Columns" button to expand the drop-down menu.
4. Select the corresponding action:

• "Add rows above" / "Add rows below": Add a specified number of new rows above or below the selected position.
• "Add columns to the left" / "Add columns to the right": Add a specified number of new columns to the left or right of the selected position.
• "Delete rows" / "Delete columns": Directly delete the current row/column.

FAQ

Q1: How to insert multiple rows/columns at a specific position?

• Solution: First select the reference position for inserting rows/columns (e.g., to insert 2 rows after row 3, first select row 3). Then, via the right-click menu or the "Rows & Columns" feature under the "Insert" tab, enter the desired number in the input box and confirm.

Q2: Will adjacent data be affected after adding rows/columns?

• Solution: Added rows/columns are inserted at the specified position. The original data at that position and subsequent rows/columns will automatically shift backward/downward. The original data content and formatting are preserved and will not be lost.

Q3: Can deleted rows/columns be recovered?

• Solution: You can undo the deletion via Ctrl+Z, but recovery is not possible after the file is closed.

Notes

• The deletion operation cannot undo the deleted data. Please back up important data in advance.
• After adding rows/columns, the data at the original position will automatically shift backward/downward, with both content and formatting preserved.