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

  1. Select the cell where you want to insert
  2. Right-click the cell and select the "Insert" drop-down menu
  3. 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

image

Right-click to Delete Cells

Feature Entry

Right-click a cell → "Delete" drop-down menu

  1. Select the cell(s) to delete
  2. Right-click the cell and select the "Delete" drop-down menu
  3. 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

image

Insert Cells from the Ribbon

Feature Entry

"Home" tab → "Rows and Columns" drop-down menu → "Insert Cells" drop-down menu

  1. Select the cell where you want to insert
  2. Click the Home tab
  3. Select the Rows and Columns drop-down menu
  4. Click the "Insert Cells" drop-down menu
  5. 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

image

Delete Cells from the Ribbon

Feature Entry

"Home" tab → "Rows and Columns" drop-down menu → "Delete Cells" drop-down menu

  1. Select the cell(s) to delete
  2. Click the Home tab
  3. Select the Rows and Columns drop-down menu
  4. Click the "Delete Cells" drop-down menu
  5. 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

image

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