Feature Summary
The Insert and Delete Cells feature is used to add or remove cells in a spreadsheet, supporting operations on entire rows, entire columns, or specified ranges, and automatically adjusting the table structure.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | Some features require a membership subscription |
| Version Restriction | No version restrictions |
Operation Steps
Right-click to Insert Cells
Feature Entry
Right-click a cell → "Insert" drop-down menu
- Select the cell where you want to insert
- Right-click the cell and select the "Insert" drop-down menu
- Choose an insertion method:
- Insert cells, shift active cells right: Shift the current cell and cells to the right to the right
- Insert cells, shift active cells down: Shift the current cell and cells below downward
- Insert row above: Insert an entire row above
- Insert row below: Insert an entire row below
- Insert column to the left: Insert an entire column to the left
- Insert column to the right: Insert an entire column to the right

Right-click to Delete Cells
Feature Entry
Right-click a cell → "Delete" drop-down menu
- Select the cell(s) to delete
- Right-click the cell and select the "Delete" drop-down menu
- Choose a deletion method:
- Shift cells left: Cells to the right fill the empty space
- Shift cells up: Cells below fill the empty space
- Entire row: Delete the entire row
- Entire column: Delete the entire column
- Delete empty rows (membership required): When multiple rows are selected, delete the blank rows among them

Insert Cells from the Ribbon
Feature Entry
"Home" tab → "Rows and Columns" drop-down menu → "Insert Cells" drop-down menu
- Select the cell where you want to insert
- Click the Home tab
- Select the Rows and Columns drop-down menu
- Click the "Insert Cells" drop-down menu
- Choose an insertion method:
- Insert row above: Insert an entire row above
- Insert row below: Insert an entire row below
- Insert column to the left: Insert an entire column to the left
- Insert column to the right: Insert an entire column to the right

Delete Cells from the Ribbon
Feature Entry
"Home" tab → "Rows and Columns" drop-down menu → "Delete Cells" drop-down menu
- Select the cell(s) to delete
- Click the Home tab
- Select the Rows and Columns drop-down menu
- Click the "Delete Cells" drop-down menu
- Choose a deletion method:
- Delete cells: Delete the selected cells
- Delete rows: Delete the entire row
- Delete columns: Delete the entire column
- Delete empty rows (membership required): When multiple rows are selected, delete the blank rows among them

FAQ
Q1: Will inserting cells affect formula references?
- Solution: Yes. After inserting or deleting cells, related formula references will be automatically adjusted.
Notes
- Inserting entire rows/columns is more commonly used
- Before deleting cells, confirm that other data will not be affected
- You can use Command + Z to undo the operation