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
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
- SergeiBaklanSep 27, 2024Diamond Contributor
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.
- sbernard1550Sep 27, 2024Copper ContributorI 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
- SergeiBaklanSep 27, 2024Diamond Contributor
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.
- sbernard1550Sep 27, 2024Copper Contributor
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!