- dotTech - https://dottech.org -

How to delete all blank rows at once in Excel [Tip]

If you’re working on a spreadsheet with lots of rows and columns to fill, you could end up deleting some blank rows that you don’t really need. For example, if you’ve deleted data from specific rows, they’ll be left blank and can obstruct the flow of your list. Now, since you’re here, you’re probably looking for a way how to delete all blank rows on your Excel sheet at once and in just a few clicks. Well, that’s quite simple. You just need to follow the steps listed below.

How to delete all blank rows at once in Excel

delete all blank rows Excel at once [1]

delete all blank rows Excel at once b [2]

It’s as simple as that.

On the other hand, do note that this method works best when you’re using Excel 2007 or 2010.