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.
- 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
Here's my grid: I select B2-i6. Then go to Special and then select "Delete Sheet Rows" ;
I get this in the end:
BUT, if I right click once the "Go to Special " is selected, and ask to delete and do a 'Delete Shift Cells Up", then it works nicely.
Anyway, thanks again!
- 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!