Lesson#131: Find out complete blank rows in the Excel datasheet

Lesson#131: Find out complete blank rows in the Excel datasheet

In this post, I will show you a simple trick by which you can find out complete blank rows in the Excel datasheet.

I have made an arbitrary sheet to describe. I have to find out only completely blank rows in this sheet then I need to delete them.

blank rows in the Excel

Then I added a simple formula to the very next column of the data table.

=COLUMN()-1=COUNTBLANK(A2:L2)

Now I will drag the formula up to the last row of the data table. This formula will return either TRUE or FALSE.

blank rows in the Excel

Now I need to add a filter on the header row then I will select TRUE on the column where I have put the formula.

blank rows in the Excel

See the result. Now I can select and delete these rows easily. In this way, it is very easy to find out complete blank rows in a data sheet.

Read more.

Lesson#153: How to insert blank rows after every row in the sheet, No Formula method

See also  Lesson#133: Auto numbering formulas in Excel

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

0 Comments on “Lesson#131: Find out complete blank rows in the Excel datasheet

Leave a Reply

Your email address will not be published. Required fields are marked *

*