How to Delete Multiple Blank Rows

Question

I have a spreadsheet that contains ~2,500 rows.&nbsp; There are hundreds of blank rows scattered throughout.&nbsp; I want to remove them all but don't want to select them 1 by 1.&nbsp; I already read some of the previous solutions but couldn't get any of them to work.&nbsp; Please advise.

abiola1 · Answer

Hello, I wrote a blog on this same question. Do check it and follow the stepshttps://www.exceljetconsult.com.ng/home/blog/delete-blank-rows-without-impacting-non-contiguous-columns/

sergeibaklan · Answer

dadaoftwins&nbsp;
You may apply filter to your range selecting blank rows, select filtered range rows, delete them, clear the filter.,

Forum Discussion

How to Delete Multiple Blank Rows

2 Replies

Resources