Delete Cells

How to Delete Cells in Google Sheets

Google Sheets Training

Google Sheets Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Delete Cells

If you later decide you no longer need a group of cells, columns, or rows, you can delete them. Deleting a cell differs from clearing a cell's content, as a "hole" is created by the deleted cell(s) and adjacent cells will move to fill that hole.

Delete Cells

  1. Select the cell or cell range you want to delete.
  2. Click Edit on the menu bar.
  3. Select a delete option.
    • Delete values: Deletes the values(s) from a cell or cell range.
    • Delete row: Deletes the selected row(s).
    • Delete column: Deletes the selected column(s).
    • Delete cells and shift up: Deletes the selected cells and shifts the cells below it up.
    • Delete cells and shift left: Deletes the selected cells and shifts the cells to the right of it to the left.
    Delete Cells

The cell(s) are deleted.

You can also delete cells by right-clicking the selected cell(s) and selecting Delete from the contextual menu.

Delete Rows and Columns

  1. Select the row or column you want to delete.
  2. Click Edit on the menu bar.
  3. Select Delete row or Delete column.
    Delete Cells

The rows or columns are deleted. Remaining rows are shifted up, while remaining columns are shifted to the left.