Forum Discussion
Delete Empty Rows Quick?
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.
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.
Let's say you have data in columns A to T, with headers in A1:T1.
Enter the following formula in U2 (i.e. in row 2 in the first empty column):
=SUM(--(A2:T2<>""))
Fill down to the last used row. The formulas will return 0 in rows that are completely empty in columns A to T.
You can filter column U to display on;y the 0 results.
Delete the visible rows, then turn off the filter.
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!
