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
Thank you. This tip helped me quickly clean up a sheet.