Forum Discussion
Delete Empty Rows Quick?
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
It deletes all rows in selected range which have blank cells. If blank column is selected, cells in all rows in it are blank. Thus all rows are deleted.
Again, the main point is to select the range correctly at the beginning. That could be one or few columns only.
How do I remove the blank rows without deleting everything? If I do it your way everything gets deleted because every row has at least one blank cell.
Thanks for that. I'm familiar with the path, but i never get what i want.
In my table I also have blank columns. It messes things up. At least on my end..
I just want the blank rows to go, just the rows.
Thx!
