You may already be familiar with how to delete a row in Google Sheets, as it is a useful way to fix a problem that is very common when editing spreadsheets. While deleting a single row in this manner isn’t particularly time-consuming or inefficient, it can become so if you need to delete a lot of rows from your spreadsheet.
Fortunately Google Sheets makes it possible for you to select multiple rows at a time so that you can delete all of them with one action. You are able to select rows that are separated from one another, as well as groups of consecutive rows. Our guide below will show you the steps to take to delete multiple rows from a spreadsheet in Google Sheets.
Deleting More Than One Row at a Time in Google Sheets
The steps in this article were performed in the Web browser version of Google Sheets. The Web browser being used is Google Chrome.
Step 1: Go to your Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet file containing the rows that you want to delete.
Step 2: Hold down the Ctrl key on your keyboard and click each gray row number to the left of the spreadsheet for each row that you want to delete.
Step 3: Position your mouse cursor over one of the selected rows so that it switches to a hand icon, then right-click one of the selected rows and click the Delete selected rows option.
Note that you can delete a group of consecutive rows by clicking the top row number, holding down the Shift key on your keyboard, then clicking the bottom row number. This will select the entire range of rows, which you can then delete in the same way.
You can use a very similar technique if you need to delete columns from your spreadsheet as well.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.