MS Excel - deleting blank rows

This technique will allow you to delete all rows that have blank cells in a particular column.

1. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
2. Now, select the cells in one column from the top of your list to the bottom.
3. Make sure that all the blank cells in this selected range are the rows you want to delete.
4. Select Edit, Goto (or press F5).
5. Click the Special button.
6. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
7. Now choose Edit, Delete, select the Entire Row option and click OK.

If you work with large lists of data in Excel, this tip will save you a lot of time.

Link: http://www.theexceladdict.com/tutorials.htm