Andrea Moro's blog

Deleting blank rows on Excel

in Tips

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 […]