Hi,

I have a large spread sheet with columns and rows that contain blank cells. I want to delete all the blanks, I used to be able to do this in older versions of Excel but can't figure out how to do it in 2010. I can't filter as some of my columns don't have headings.

Example:

A B C D
1 2 3
1 2
1 2

I know there's probably a simple way to do it so your help will be appreciated.