DISQUS

Lee · 10 months ago

incorrent... it selects all empty _cells_, not rows, and then deletes any row that has at least one empty cell
Pete · 9 months ago

I used Data > Remove duplicates" It leaves you with only 1 blank row. This of course assumes you have no other duplicates.
Bob · 9 months ago

Thanks mate.... cheers!
Bob · 9 months ago

Sorry... agree with Lee, all rows with blanks are deleted and this is not what I want
Bob · 9 months ago

Agree with Lee, can try sorting data on spreadsheet then all blank rows will be together where they can be deleted
Ann · 5 months ago

Thank you
meka · 1 week ago

Yes, this won't work if you select the entire spreadsheet. Try only selecting one column that you know has data in every column you need saved. Then follow the steps above to delete the empty rows.