The first thing we’ll do is insert a column and number it consecutively. Let’s say we have the following set of data in Excel and we want to get rid of the blank lines:
Luckily, there is a simple and very effective way to delete blank lines without any macros. Note that these methods will work for any version of Excel, from Excel 2003 all the way to Excel 2016 and beyond. In this article, I’ll show you a couple of ways you can delete blank rows in Excel and the advantages and disadvantages for each method. Also, if it doesn’t work properly, you may have no idea how to change the macro for your particular Excel file. However, if you’re not familiar with macros, this method can be difficult to implement.