How to select and delete blank rows in Excel

To select and delete blank rows in your Excel sheets :
1. select your columns
2. press F5
3. in the opened box click special
4. select blanks
5. in home tab go to cells group box and from delete section click "Delete Sheet Rows"