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...
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.
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!
