Forum Discussion
Jessica Darnell
Apr 12, 2018Copper Contributor
Mass Delete Multiple Rows in Excel Sheet
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
- shorttail765Copper Contributor
- PositiveEnergyBrass Contributor
Jessica Darnell How to quickly delete multiple rows in multiple CSV Excel files
https://youtu.be/2mx9bZ7xz5o - Damien_RosarioSilver Contributor
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
Hi Jessica,
As variant you may Data->Filter blank rows and delete them at once. Hided by filter rows won't be deleted.