How to remove or delete empty or blank rows in Google Sheets?

How to remove or delete empty or blank rows in Google Sheets?

1. Select the Rows.

2. Go to Data menu and select “Create a filter”.

 

3. Select Clear and then select Blanks. Click OK Button.
4. Selected the Blank rows. Right Click and select “Delete selected rows”

5. Select Remove Filter from Data Menu.

Output:
 

 

Leave a Reply