How to Delete Blank Rows in Excel
— The Right Way
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
There’s something inherently irritating about spreadsheets with blank rows.
Excel sets out your data so nicely—and then its hard work is interrupted by blank rows.
It seems unjust.
Fortunately, you can remove blank rows with just a few clicks!
First, we’ll show you the manual way to do it, in case you only have a few rows to delete.
Then we’ll look at one of the common ways people recommend deleting blank rows—and show you why it’s a bad idea.
Finally, we’ll go over at an effective way of getting rid of blank rows.
*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.