Here is a small tip for those using Excel 2010 who want to remove all blank rows in an easy way without having to remove each blank row manually. Please note that this tip applies to removing multiple columns as well.
First select the portion of the spreadsheet from where you wish to remove the blank rows and then hit the Home tab. Here navigate to the Editing options and choose the Go To Special option under the Find & Select option.
In the Go to Special dialogue box, choose Blanks and hit OK.
All the blank rows will be selected.
Now choose the Delete Sheet Rows option under the Delete drop down box.
If you want to remove blank columns, select the portion of the spreadsheet from where you want to delete the blank columns, follow all steps as listed above and finally in the end select the ‘Delete Sheet Columns’ option.
For more, learn how you can delete duplicate rows in Excel.