Yes thanks but this seems limited to the selected column. The worksheet has
rows that may have blank cells in some columns but not all. What I need to
delete are all empty rows only.

"Gord Dibben" wrote:

If for sure you have a blank row between each data row.

Select a column.

F5SpecialBlanksOK

EditDeleteEntire Row


Gord Dibben MS Excel MVP

On Thu, 31 Aug 2006 16:25:02 -0700, AinSF
wrote:

how do i find and delete all empty rows in an excel worksheet that was
created by exporting a double spaced crystal report ?