Microsoft Excel : How to remove empty rows from the datasets

 

Prerequisite : Please download ASAP Utilities and Install it.

Steps for installation  

After installing , you will be able to see ASAP Utilities as a add on . Please check the image down below.

To Remove Empty Rows.

Step 1 : Select One Column from the Column Header ( By Clicking on "A" or "B" or " C" )

Step 2 : Go to ASAP Utilities --> Columns and Rows -->  12th Option Delete all empty rows. 

Before :                                                                                               After : 

Voila ! - the perfect way to remove empty rows, with least effort!

Don't forget to like, share and subscribe. Thank you very much.