Best Microsoft Excel Bloggers

Thursday, February 18, 2010

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.

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek