How to☝️ Delete Rows in Google Sheets [Desktop & Mobile Guides]

To delete rows in Google Sheets, highlight the rows that you want to remove, right-click anywhere on the sheet, and choose “Delete rows.”

If you want to quickly filter and remove empty rows, use the filter option that we’re going to show you below.

How to Delete Multiple Rows in Google Sheets

Let’s start with the easiest part and gradually tackle more advanced techniques.

If you simply want to delete multiple rows in Google Sheets, you can quickly do that by following these steps:

1. Highlight the rows you want to remove (in our case, rows 5-7).

2. Right-click anywhere on the spreadsheet to pull up the contextual menu.

3. Choose “Delete rows 5-7.

How to Delete Multiple Rows in Google Sheets

Once there, you’ve successfully removed the rows from your spreadsheet. Good riddance.

The Data

How to Find and Delete Empty Rows in Google Sheets

What if you want to remove empty rows from your data table?

When you have tens of rows to sift through, it can be easily done manually. But what if you have to work through thousands of rows? That’s where filters come into play.

To delete empty rows from your table in Google Sheets regardless of its size, here’s what you need to do:

1. Highlight the data that you want to filter (A1:B11).

2. In the toolbar, select “Create a filter.

Create a Filter Option

3. Click a drop-down list in the column header.

4. Hit “Clear” to de-select all the available filtering options.

5. Select “(Blanks)” to highlight only empty rows.

6. Click “OK” to close out.

The Filter

7. Highlight the filtered empty rows that you want to remove (rows 5-7).

8. Right-click anywhere on the sheet to open the contextual menu.

9. Choose “Delete selected rows” to remove all the empty rows from your data table. The hidden rows won’t be affected, so rest assured that your data is safe.

The Delete Selected Rows Option

10. Hit the “Remove filter” button to exit the filter view.

The Remove filter option

This is just a quick example of how you can apply filters. When you add custom formulas or conditional formatting to the equation, that’s where you take it to the next level.

Let me show you a quick example of how to delete rows in Google Sheets based on conditional formatting.

How to Conditionally Delete Rows in Google Sheets

To show you the ropes, we applied conditional formatting to our data table. Let’s filter out the rows where the names of the categories are highlighted in green and remove these rows.

The Data in Google Sheets

1. Select the entire data table (A1:B11).

2. In the toolbar, choose “Create a filter.”

Filter

3. Open a drop-down menu in the header row.

4. Hover over “Filter by color.”

5. Click “Fill Color.

6. Choose “#B7E1CD” (green).

7. Click “OK.

Filter by color

Now that we have the rows filtered out, it’s time to get rid of them.

8. Highlight the filtered rows.

9. Right-click anywhere on the sheet and choose “Delete selected rows.

Delete selected rows

10. Click “Remove filter” to close out.

The Remove filter option

After removing the filter, you get your data table without the rows that have conditional formatting applied to them.

The Data

How to Delete Rows in Google Sheets on Mobile Devices

Are you looking for a way to delete rows in Google Sheets on iPhone or Android? Here’s how you can do that:

1. Select multiple rows by dragging the edge of the blue selection box up or down.

2. Tap on the rows you selected to pull up a contextual menu, and choose “Delete.

How to Delete Rows in Google Sheets on Mobile Devices

Here you go! You’ve just successfully deleted rows using the Google Sheets mobile app.

Data in Google Sheets on Mobile Devices

How to Delete Rows in Google Sheets: FAQs

Here are some of the most frequently asked questions when it comes to the process of removing rows in Google Sheets

What Is The Shortcut To Delete Rows And Columns In Google Sheets?

Yes, there’s a quick way to delete rows or columns in Google Sheets using a shortcut. 

Once you have your data selected, press Alt + Shift + E to pull up a pop-up menu. Then, press D to open the Delete submenu, and hit D again to delete the rows you selected.

Why Can’t I Delete A Row In Google Sheets?

There are a few reasons why you might not be able to delete a row in Google Sheets. It could be that the row is locked, it’s protected, or you don’t have permission to delete it.

  • If the row is locked, it will be displayed with a lock icon in the top-left corner of the cell. To unlock the row, click on the padlock and enter your password if prompted.
  • If the row is protected, it will be displayed with a shield icon in the top-left corner of the cell. To unprotect the row, click on the shield and enter your password if prompted.
  • If you don’t have permission to delete a row, you’ll need to ask the owner of the sheet for permission.

Is There A Way To Delete Empty Rows Using A Formula?

No, as of this writing, there’s no way to actually delete rows using a custom formula. However, you can do that in Google Apps Script with a bit of coding.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X