Deleting empty rows

F

Felix

How can I easily delete empty rows on a huge worksheet (other than sorting)?
(Excel 2007)

Felix
 
M

Muhammed Rafeek M

Use filter. Or Select blank rows by using Edit->Goto->Special->Blanks, option
and delete
 
Top