Forum Discussion
Delete Empty Rows Quick?
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.
Thankyou bro it works 😍
When i do what you suggested, it also deletes the columns. And at the end, there is nothing left on my sheet, at all.
I'm only trying to delete the blank rows.
Any idea what i'm doing wrong ?
Thx! Suzanne
Assume we have such range, select it, GoTo Special and select Blanks
Click Ok, right after that Delete -> Delete Sheet rows
Click on it, now rows are deleted
That's straightforward, the only is to select the range correctly at very beginning.
- I tried with no blank columns, works just great! For some reason when there are blank columns in the table, and even though i ask to delete only the rows, it does weird things. Please try
- Thank you. This tip helped me quickly clean up a sheet.
- Thanks it works
- This was exactly what I needed, thank you!
Naragon1 , you are welcome
- Thank You!!
Just what I needed!!!medstan , you are welcome
