How to delete blank rows from Excel worksheet

How to delete empty or blank rows in an Excel worksheet with data
Blank or empty rows in an Excel worksheet can hinder data analysis like using Auto Filter.
In this video we demonstrate how to delete the blank or empty rows using a macro. Earlier we demonstrated how to remove the blank rows without using a macro.
We use a for loop to delete the blank rows since we know where oure data starts and ends.
After the deletion of the blank rows we observe that we can now analyze our data using Auto-Filter quickly and easily.

Further reading:
How to remove blank or empty rows in Excel?

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.