See all How-To Articles

How to Delete Multiple Cells in Excel & Google Sheets

This tutorial will demonstrate how to Delete Multiple Cells in Excel & Google Sheets.

select multiple cells 6

Delete Adjacent Cells

Click in the first cell that you wish to delete and then drag your mouse to the last cell you wish to delete.

DeleteMultipleCells Select

Right click on the selection, and then click Delete.

DeleteMultipleCells right click

OR

In the Ribbon, select  Home > Cells > Delete > Delete Cells.

DeleteMultipleCells ribbon

A Delete dialog box will appear asking you where you wish to move the remaining cells to, or if you want to actually delete the entire row or column that the selected cells are in.  Select the appropiate acction and click OK.

DeleteMultipleCells non adjacent warning

Delete Non-Adjacent Cells

Click in the first cell that you wish to delete and then, holding down the Control key, click on each additional cell that you wish to delete.

 

DeleteMultipleCells select non adjacent

 

Right click on one of the selected cells, and then click Delete.

DeleteMultipleCells non adjacent right click

 

OR

In the Ribbon, select  Home > Cells > Delete > Delete Cells.

DeleteMultipleCells non adjacentribbon

 

The Delete dialog box will once again appear.  Select the appropiate acction and click OK.

DeleteMultipleCells non adjacent warning

How to Delete Multiple Cells in Google Sheets

Deleting multiple adjacent cells in Google Sheets works much the same as it does in Excel.

You can select adjacent cells by clicking on the first cell you require, and dragging down or across to the last cell you wish to delete.

You can then, as with Excel, either right- click on any selected cell, and then select the appropriate Delete cells option from the quick menu (eg Delete cells and shift up).

DeleteMultipleCells gs right click

OR

In the Menu, select Edit  > Delete and then select the appropriate option (eg: Cells and shift up)

DeleteMultipleCells gs menu

 

You cannot delete selected non-adjacent cells in Google Sheets.