Mass Delete Multiple Rows in Excel Sheet

Question

Can someone tell me if deleting multiple blank rows in a spreadsheet is possible through a mass deletion process? Or will I still have to delete them by clicking on each row and then deleting it??

Thanks

sergeibaklan · Answer

Hi Jessica,
&nbsp;
As variant you may Data-&gt;Filter blank rows and delete them at once. Hided by filter rows won't be deleted.

damien_rosario · Answer

Hi Jessica&nbsp;There is a previous solution that may help you:&nbsp;https://techcommunity.microsoft.com/t5/Excel/Need-help-with-Excel/td-p/144356&nbsp;CheersDamien

positiveenergy · Answer

Jessica Darnell&nbsp;How to quickly delete multiple rows in multiple CSV Excel fileshttps://youtu.be/2mx9bZ7xz5o

shorttail765 · Answer

Jessica Darnell&nbsp;You can try this trick..:Fastest trick&nbsp;to mass delete multiple rows in excel sheet&nbsp;

Forum Discussion

Mass Delete Multiple Rows in Excel Sheet

Share

Resources