View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do i find and delete all empty rows in an excel worksheet

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 ?