See all How-To Articles

Delete Multiple Rows / Columns in Excel & Google Sheets

This tutorial will demonstrate how to delete multiple rows or columns in Excel and Google Sheets.

deletemultiple intro

 

By selecting multiple rows or columns in Excel, we can quickly delete the required amount of rows or columns using our right-mouse button or the Excel Ribbon.  This can also be doing using VBA.

Deleting Adjacent Rows

To delete multiple rows into your worksheet, select the rows you wish to delete by clicking on the row header and dragging down to the header of the last row you wish to delete.

deletemultiple select rows

Right-click on the row header and select Delete.

deletemultiple delete rows

OR

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

deletemultiple ribbon delete rows

 

Deleting Non-Adjacent Rows

To delete multiple non-adjacent rows into your worksheet, select the first row you wish to delete by clicking on the row header, and then, holding down the Control key, click on each additional row that you wish to delete.

deletemultiple select non adjacent

Right-click on the row header and select Delete.

deletemultiple non adjacent delete

OR

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

 

deletemultiple non adjacent delete rows

Delete Adjacent Columns

To delete adjacent multiple columns into your worksheet, select the columns you wish to delete by clicking on the column header and dragging across to the header of the last column you wish to delete.

deletemultiple select adjacent columns

Right-click on the column header and select Delete.

deletemultiple right click delete columns

OR

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

deletemultiple ribbon delete columns

Delete Non-Adjacent Columns

To delete non-adjacent multiple columns into your worksheet, select the columns you wish to delete by clicking on the first column header and then, holding down the Control key, click on each additional column header of the columns you wish to delete.

deletemultiple select non adjacent columns

Right-click on the column header and select Delete.

deletemultiple delete non adjacent columns

OR

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

deletemultiple ribbon delete non adjacent columns

Delete Multiple Rows / Columns in Google Sheets

Deleting multiple rows and /or columns in Google Sheets works much the same as it does in Excel.

You can select adjacent rows or columns by clicking on the row or column header, and dragging down or across to the required row or column header of the last row or column you wish to delete.

You can select non-adjacent rows or columns by clicking on the first row or column header, and then, holding down the Control key, click on any further row or column headers required.

You can then, as with Excel, either click on the row/column header with your right mouse button and select the Delete option from the quick menu (eg Delete rows 2-8).

deletemultiple gs rows right click

OR

In the Menu, select Edit > Delete  and then select the required options (eg: Rows 2-8) as shown below.

deletemultiple gs rows menu