[Google Sheets] How to Remove Blank Rows
If you’ve ever been working on a data set that contains blank rows that you want to remove, but don't know how or you want to learn a more efficient way to do it. Watch this video.
Welcome to tip bytes, a channel dedicated to making you more proficient in google sheets.
We have a dataset with the name, birthday, location, and age of customers. There are a few blank lines as well as a few pieces of information missing.
If you want to delete the blank rows you can do so by right-clicking anywhere on the row that you would like to delete and then select “Delete row” from the pop-up menu.
Another way to do this would be to select the row that you would like to delete by left-clicking the number label for the row on the left-hand side of the sheet and use the Ctrl minus hotkey to remove the row.
If you need to remove multiple rows you can select all rows that you would like to delete by left-clicking one row that you would like and while holding the Ctrl key select all the rows you would like to delete and either right-click and select delete or use the Ctrl minus hotkey.
If you have a large dataset that would be too time-consuming to find each blank row you can apply a filter by selecting all of the data and use the “Create a Filter” button in the menu bar. Then select the column that you would like to filter and select “Clear” and then “(Blanks)” and then “OK”. Now you can select all blank rows by clicking the first blank row, holding shift, and then clicking the last blank row. Now if you remove the filter you will be left with the non-blank rows
We could also use the COUNTA function if there isn’t a column with blanks only when the entire row is blank. As an example, if the dataset was missing the name in cell B2 there wouldn’t be a single column we could use to filter to blank data since not ever blank in the column means the entire row is blank.
If we create a new column header called “data count” and use the COUNTA function we can then apply the data filter and filter the new “data count” column for zeros and delete those rows.