How to Delete Multiple Rows in Google Sheets

Often you will need to delete the data in a spreadsheet. Whether that data is no longer relevant, or it is simply incorrect, it’s rare that a spreadsheet won’t need to be edited. But sometimes the entire structure of the sheet might need to be changed, which can leave you looking to delete rows from it.

You may have discovered how to delete a row in Google Sheets, but that method can be tedious if you have a lot of rows that you wish to remove. Fortunately you are able to delete multiple rows in Google Sheets by following our tutorial below.

See also

How to Delete More Than One Row at a Time in Google Sheets

The steps in this article were performed in Google Chrome, but will work in other desktop Web browsers as well. This is going to permanently delete entire rows from your spreadsheet. If you would prefer to keep that data in the sheet, you might consider hiding those rows instead.

Step 1: Sign into your Google Drive at and open the spreadsheet containing the rows you want to delete.

Step 2: Click the top row that you want to delete, Hold the Shift key on your keyboard, then click the bottom row that you want to delete. You can release the Shift key once all the rows are selected. Note that you can instead hold down the Ctrl key and click row numbers if the rows that you want to delete are not all next to each other.

how to delete more than one row in google sheets

Step 3: Right-click on one of the selected row numbers, then click the Delete rows option.

how to delete multiple rows in google sheets

You can use this same method if you want to delete multiple columns as well.

Do many of the cells in your spreadsheet have different formatting, and you don’t like the way they look? Learn how to clear formatting in Google Sheets and create a more consistent look for your data. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.