Forum Discussion
Delete Empty Rows Quick?
I have a worksheet with thousands of rows and a blank row between each row with data. Is there a way to remove all those blank rows quickly? I need to sort by a column and I can't right now. I ass...
If without shortcuts - select any column within range, on ribbon Find&Select->Go to Special->Blanks->Ok
All blank cells will be selected. With that Cells->Delete->Delete Sheet Rows
In my case, and it sounds like the OPs also, I want the rows that are completely blank to be deleted, but rows that have a single blank cell to be left alone. Your solution does not address this but deletes entire rows with data even if only one cell in the row is blank.