If more than one column has blank values, just pick one. Note that you want to sort the column that have the blank values in it. For Sort By, choose Column B and then click OK. Then click on the Sort button on the Data tab. Here’s what the sheet should look like before we sort the animal name column: Now select both columns and click on the Data ribbon in Excel. You might ask why we would want to do this? Well, if the order of the rows matters, when we sort Column A to get rid of the blank lines, there will be no way to get the rows back in the order they were before sorting.

Let’s say we have the following set of data in Excel and we want to get rid of the blank lines: The first thing we’ll do is insert a column and number it consecutively. Method 1 – Add Sorting Column 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. The most common way to delete blank lines in Excel, at least as mentioned online, is to use some sort of Excel macro. If you have thousands of rows, manually deleting blank lines is a major pain and virtually impossible. Whatever type of data you may have in Excel, there are many occasions where you will also have a bunch of blank lines throughout the file. One of the most common tasks in Excel is deleting blank rows.

Delete blank columns in excel for mac