You can use Excel macros to clean up your data, but it can be difficult if you aren’t familiar with macros. This tutorial will show you different ways to delete blank rows in any Excel version, from Excel 2003 to Excel 2016 and beyond.
See how to remove blank lines in Excel with formulas and VBA: delete row if entire row is empty, remove all empty rows at once, delete row if cell is blank, and more.