• Skip to main content
  • Skip to primary sidebar

Nerd Excel

Excel Simplified

  • Excel
  • Google Sheets
  • Word
  • Google Docs

How to Delete Blank Rows in Google Sheets

By: Salman Patwegar

While manually deleting rows sounds like a straightforward task, it can quickly become a nightmare, especially if you are working on a big spreadsheet.

Delete Blank Rows in Google Sheets

First you have to go through the entire spreadsheet looking for blank rows and then manually delete them.

Luckily you don’t have to manually delete blank rows in Google Sheets, as there is an easy way to have them all deleted at once. In this tutorial, we will be showing you exactly how.

Delete Blank Rows in Google Sheets

The easiest and most efficient way of deleting blank rows is by first filtering the data set and then deleting the blank rows.

Here is how you can do this:

1. Select the entire dataset: Select your entire dataset, including blank rows and columns. (See image below)

Select Entire Dataset in Google Sheets

2. Click on Data > Create a Filter: Next, click on the Data tab from the top menu and then from the dropdown menu, click on Create a filter.

Create a Filter in Google Sheets

3. Click on the Dropdown Icon: Now with the filters created, click on the dropdown icon on any of the columns.

4. Click on Clear: From the dropdown menu click on Clear to deselect all the options.

Clear Filtered Data in Google Sheets

5. Select (Blanks) option: Next select the (Blanks) option and then click on Ok to sort the data.

Display Blank Rows in Google Sheets

You will now be shown only the blank rows from your dataset. Now you need to delete these blank rows.

6. Click on the first row: Click on the first row to select it.

7. Hold the Shift key and Click on the last row: With the first row selected, hold down the shift key and click on the last row in the dataset.

Select Blank Rows to Delete in Google Sheets

All the blank rows should now be selected.

8. Click on Delete Rows x – x option: Now with the blank rows selected, right click on the column and then click on the Delete Rows x – x option. In my case it says Delete Rows 5 – 11, but these numbers will be different for you, depending on how big your dataset is.

Delete Blank Rows in Google Sheets

Note: Even though it says delete rows 5 – 11, it will only delete the blank rows between 5 to 11 and not the rows 5 – 11.

9. Click on the Filter Icon: Now with the blank rows deleted, click on the Filter icon from the top menu (located at the far-right side) and the dataset with the blank rows removed will now appear on your screen.

Filter Icon in Google Sheets

And that’s it! You have successfully managed to delete blank rows in Google Sheets.

Primary Sidebar

Popular Now

  • How to Calculate Age in Google Sheets
  • How to Sort by Date in Google Sheets
  • How to Generate Random Numbers in Google Sheets
  • How to Generate Random Numbers in Excel
  • How to Unprotect Excel Sheet Without Password

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Nerdexcel.com · All Rights Reserved