While manually deleting rows sounds like a straightforward task, it can quickly become a nightmare, especially if you are working on a big spreadsheet.
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)
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.
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.
5. Select (Blanks) option: Next select the (Blanks) option and then click on Ok to sort the data.
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.
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.
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.
And that’s it! You have successfully managed to delete blank rows in Google Sheets.