Published on October 31, 2023 by Jake Sheridan
Welcome to this tutorial where you’ll learn how to delete empty cells in Google Sheets. We’ve all been in situations where our data contains empty cells and rows. It can be frustrating and time-consuming to manually delete them. Fortunately, Google Sheets offers a quick and efficient solution for removing these empty cells. In this guide, we’ll show you how to use the Filter tool to quickly delete empty cells in Google Sheets.
Deleting Empty Rows in Google Sheets
Here’s how to delete empty rows in Google Sheets:
Step 1
First, select the entire table that contains empty rows.
Step 2
Next, click on the Data menu and select the Create a filter option.
Step 3
The selected table should now have a filter icon for each header.
Step 4
Click on the filter icon of a field to display the filter options. Make sure to choose a required field for the row.
Click the Clear button to deselect all values, then select the (Blanks) value.
Press the OK button to proceed.
Step 5
Google Sheets should now only display the rows with empty values for the given field.
Step 6
Right-click the selection and click on the Delete selected rows option.
Step 7
Next, click on the filter icon of the same column as before. Click on the Select all option to display all remaining non-empty entries.
Step 8
All empty rows should now be removed from the table.
Step 9
Another way to quickly delete empty rows is by sorting them.
Start by selecting the range from which you want to delete the empty rows.
Step 10
Click on the filter icon to apply a filter to the selected range.
Step 11
Click on the filter icon of a field and select the Sort A to Z option.
Step 12
The empty rows should appear at the bottom of the sorted table.
Select these rows with your cursor and delete them from the workbook.
Step 13
You should now have a table without any empty rows.
Summary
This guide should provide you with all the necessary information to delete empty cells in Google Sheets. Feel free to make a copy of this workbook example and try it out for yourself.
And don’t forget to visit Crawlan.com for more tips and tutorials on Google Sheets and other productivity tools.
Share these juicy secrets with your best friends!
