Deleting Blanks

Often when you import data, you end up with a lot of BLANK ROWS.

Here is an easy way to get rid of them.


Excel 2003 method:

•  Select your data
• Select Edit and Go To
• Click Special…
• Click OK
• Select Edit
• Select Delete...
• Select Entire Row
• Click OK

Excel 2007 method:

•  Select your data
•  Select Find and Select on the Home Tab
•  Select Go To Special..
•  Select Blanks
•  Click OK
•  Select the drop-down arrow under Delete in the Cells group on the Home Tab
• Select Delete Entire Row
• Click OK

You could also right-click and select Delete instead of going to the Ribbon if you preferred.