Google Sheets is one of the best products offered by Google. It helps you to record and organize large volumes of data in simplified sheets.
When working with Google Sheets, you are likely to end up with a lot of empty rows and cells. It could be that you deleted the data from some of the cells or rows. The best thing to do is to delete the empty rows in the Sheets. By doing so, you can make your Sheets look tidy and well-organized.
Now the question is how to delete empty rows in Google Sheets? Deleting one or two empty rows manually is possible. But when you have hundreds of them, you need to find out an efficient way.
In this guide, we will provide a step-by-step guide to remove empty rows in Google Sheets. The steps are easy to follow and anyone can do it.
Steps to delete empty rows in Google Sheets:
- Open the sheet you want to remove the lines from:
- Select the entire sheet or dataset :
- Now, navigate to Data > create a Filter:
- The filter will be created:
- Next, Click on the Filter icon at the top of any column:
- Next click on Clear and select (Blanks).
- Now, select all the row and delete the rows:
- Now, all the cells will be deleted:
- Now navigate to Data > Turn off filter:
- All the blank rows will be deleted: