How To Delete Blank Rows In Google Sheets

Thankfully, there are filters and tools in Sheets that help you polish up your work. You can use this article as a guide for making improvements to your Google Sheets by eliminating any empty rows.

How to Delete Blank Rows in Google Sheets?

In order to remove random blank rows from Sheets, you need to create a filter or sort out the empty spaces. But, you can remove empty rows that are together in a much simpler way.

Delete Empty Rows that Are Together

You can use the Delete option to remove blank rows in your sheet. But, it can take several minutes to do it. You can, however, delete empty rows that are together quickly by following the methods listed below.The method mentioned above requires you to hold and drag your cursor throughout all empty rows. As an alternative way, follow the steps listed below. This method works best for sheets with many empty rows as well as those with a few.

Delete Empty Rows that Are Random

Deleting every single blank row is not practical if they’re spread randomly throughout the sheet. The use of filters or the sorting function on Google sheets is a better alternative in such a situation. 

Using Sort Function

The Sort function is an effective solution if the rows with data have serial numbers or alphabets assigned to them. Otherwise, the rows may not appear in the correct order. 

Using Filter

In Google Sheets, you can separate rows and columns by applying custom filters. Using the method mentioned below, it is possible to separate blank rows from the ones with data. Afterward, you can delete the empty rows.There are two ways to remove blank spaces from Google Sheets using filters. The filtering methods for both types of sheets are mentioned below.Some Google Sheets can be customized in such a way that they have no extra columns or rows. In such sheets, you can use a Condition filter to separate empty rows and delete them afterward. You can apply the Remove Blank filter on a sheet with all the columns and rows intact. It is possible to get rid of empty cells by transferring the rows with data to a blank sheet.