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