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
This was the easiest of all I tried today! Thank you. And if you only select the one column then I didn't have any issues with deleting rows I needed to keep.