Forum Discussion
Delete Empty Rows Quick?
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.
I saw this solution, but no explanation on how to "filter column U to display on;y the 0 results."
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!
