5 steps to easily delete blank rows in Excel

Working with spreadsheets mean inevitably to face with importing data sooner or later. And blank rows or cells are a common problem, especially if we are going to use the filter to order the items in your list, which definitely don’t love empty cell/rows (well the Windows version of Excel 2010 seems to manage pretty well them, but this is not happening with Excel 2011 for Mac).

For what sake should I add an empty row if this creates me trouble?

Well, you are probably not adding a blank row if you know this causes problem, but it is likely that before working on the spreadsheet you have used the import tool to get raw data from somewhere else (like a text file or a CSV file). So, today I will show you a very simple trick to delete blank rows from excel spreadsheets. The method applies to both Mac and Windows, but as I don’t work on a Windows regularly I’m not entirely sure the Windows version does require some additional steps.

How to delete blank rows

Here the solution, proposed in 5 easy steps.

  1. Press F5
  2. Hit on the “select” on the the “Go to” dialog just appeared
  3. From “select special” screen, select “Blanks” and press Ok
  4. With all the blank cells currently selected, press CTRL and Minus sign (-)
  5. Select “shift cells up” or “entire row” as needed.

That is all. Now you have successfully removed blank rows.