#ExcelTips: How quickly remove Empty Rows in Excel Using a Helper Column?

[larryhughes]

I used this and it worked great. Thanks!

[LeahyPhoto]

Use go to special, select blanks and delete

[gauravnainwal]

I used the sum(len) but i was getting value error then I used Counta

[bhasiswain]

Please provide this data set to practice

[muhammadharoon]

Select all press ctrl G delete empty row thanks me later