Mass Delete Multiple Rows in Excel Sheet

[Jessica Darnell]

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

[#2]

Hi Jessica,

As variant you may Data->Filter blank rows and delete them at once. Hided by filter rows won't be deleted.

[#3]

Hi Jessica

There is a previous solution that may help you:

https://techcommunity.microsoft.com/t5/Excel/Need-help-with-Excel/td-p/144356

Cheers

Damien

[#4]

@Jessica Darnell How to quickly delete multiple rows in multiple CSV Excel files
https://youtu.be/2mx9bZ7xz5o

[#5]

@Jessica Darnell You can try this trick..

:

Fastest trick to mass delete multiple rows in excel sheet