Here is another great Excel tutorial from AbleBits that will show you how to remove empty rows from an Excel spreadsheet.
Here is some more information about AbleBits and some of their Excel products:
Add-ins for Microsoft Excel: www.AbleBits.com
Free downloads for Excel 2016 (32- and 64-bit), 2013, 2010, 2007, 2003; desktop version of Office 365
The add-ins that you will find on this page are, in fact, an accumulation of our more than 15 years of experience with Microsoft Excel development. We use Excel on a daily basis and, frankly, we don’t know how we would live without our Excel tools :). Free download is available for all add-ins.