Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to delete empty cells in Google Sheets.
How To Delete Empty Cells In Google Sheets
Sometimes, you may find that your data set contains empty cells and rows. This can be frustrating, as it can be tedious to delete them manually.
Fortunately, you can use Google Sheets to quickly delete empty rows. One way is to use the Filter tool to identify all empty rows in a table.
In this guide, we will show you how to delete empty cells in Google Sheets with the Filter tool.
How to Remove Blank Rows in Google Sheets
Here’s how to remove blank rows in Google Sheets.
First, select the entire table that contains empty rows.
Next, click on the Data menu and select the Create a filter option.
The selected table should now have a filter icon for each header.
Click on the filter icon of any field to reveal filter options. Do note that the field you choose must be a required field for the row.
Click on the Clear button to deselect all values then select the (Blanks) value.
Hit the OK button to proceed.
Google Sheets should now only show rows with empty values for the given field.
Right-click on the selection and click on the Delete selected rows field.
Afterward, click on the filter icon from the same column as earlier. Click on the Select all option to reveal all remaining non-blank entries.
All empty rows should now be deleted from the table.
Another way to quickly delete empty rows is through sorting.
First, select the range you want to remove empty rows from.
Click on the Filter icon to apply a filter on the selected range.
Click on the filter icon of any field and select the Sort A to Z option.
The blank rows should appear at the bottom of the sorted table.
Select these rows with your cursor and delete them from the spreadsheet.
You should now have a table without any empty rows.
This guide should be everything you need to delete empty cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.