Excel - Deleting Empty Rows

How to delete those pesky empty rows in Excel

If you are even an occasional user of excel you have probably experienced a situation like this: You copy and paste something from a website or other source into an excel workbook, but when you do, you're left with a bunch of empty rows in between you're actual data.

There are actually two different approaches you could use if you wanted to delete the empty rows:

1. Sort your sheet
2. Use the Go To menu option and wow your friends
   

Sort Your Sheet

Simply highlight ALL your data and click on Data -> Sort, select the appropriate column and click OK. This will automatically move the empty spaces to the bottom of your sheet. Presto!!! This method does create problems, however, if you want to keep the data in it's original order.

Go To

The Go To command is a nifty little feature that can select an item(s) based on criteria that you specify. Simply select the column that contains the mix of empty and data cells by clicking on it's corresponding letter, click on Edit -> Go To... then press the 'Special' button, select the blanks option and click OK. You should see all the empty cells selected. Now click on Edit -> Delete.

Congratulations, you just saved yourself hours of selecting and deleting empty rows. Pat yourself on the back and go home early.