How to Remove Blank Rows in Google Sheets

Last Updated: April 01, 2024
puneet-gogia-excel-champs

- Written by Puneet

If you work with data sets, you often come in a situation where you find data with some unwanted blank rows in it.

In Google Sheets, you can remove those unwanted blank rows in multiple ways based on your preference.

In this tutorial, we will show you how to remove the blank rows from the data in Google Sheets.

Remove Blank Rows Manually

  • First, select the first blank row and then press and hold the “Ctrl” key (Cmd for Mac) and then select the other blank rows.
  • Once all get selected, just right click on the mouse, and click on “Delete selected rows”.
delete-blank-rows

Note: The above-mentioned manual removal of blank rows is only good if you have a very small data set or range with a few blank rows, otherwise it will become a time-consuming task to select multiple rows from the larger data set.

Remove Blank Rows Using Filter Option

The filter option is considered the most preferred method to remove empty rows.

  • First, select the entire data set including the blank rows, and then go to the “Data” tab and click on the “Create a Filter” option and it will apply filters to the headers.
remove-blank-rows-using-filter
  • After that, click on the filter icon of any column to open the filter drop-down.
  •  Here, in the drop-down, click on “clear” to unselect all the selected options and then select only the “Blanks” option and click OK.
select-blank
  • At this point, the rows with the data will get hidden and you will find only the filtered blank rows.
  • Now, select all the blank rows and then right click and select “Delete selected rows” and it will delete all the blank rows from the data set.
delete-blank-filtered-rows
  • In the end, click on the filter icon again, and then click on “Select all” and then click OK.
unfilter-data
  • Your data set is now ready with no blank rows in it.
data-without-blankrows

Remove Blank Rows Using Sort Feature

Sorting is another feature of removing unwanted blank or empty rows by moving them at the end of the data set.

  • First, freeze the top header row, if your data set has headers.
  • After that, go to the “Data” tab and then hover the mouse cursor on the “Sort sheet” option and then click on “Sort sheet by (A to Z) or “Z to A) whatever you want.
remove-blank-row-using-sort
  • Or, instead of freezing the top row, you can select the entire data set including the blank row and then go to the “Data” tab and then hover the mouse cursor on the “Sort range” and then click on “Advanced range sorting options”.
advance-range-sorting-option
  • Here, select the “Data has header row” and then choose the sorting sequence from “A-Z” or “Z-A” whatever you want and click on “Sort”.
sort-data
  • Once you are done, with any of the methods explained just above, you will get your data sorted with all the blank rows at the end of the data set.
  • In the end, if you still want to remove the blank rows from the end of the data set, select them all and right click and choose “Delete the selected rows”.
blank-rows-sorted-at-the-end

Note: The sorting method is preferable only if you are ok with the sorting of data otherwise go for the filter method where your data structure will not get sorted and remain unchanged. except for the removal of blank rows.

Remove Blank Rows Using Add On

To use any kind of “Add -Ons” you have to download them and it could be free or chargeable.

To do so, go to the “Extensions” tab and then click on “Get add-ons and then search for “Remove blanks rows” and install it.

remove-blank-rows-using-add-on

Now to use it, go to the “Extensions” tab and hover the mouse on “Add-ons” and then click on “Remove blank rows” add-on to use it.