Delete Blank Lines
If you can sort the rows, the blanks will sort to the bottom, and
effectively "disappear"
OR, you can put in a formula outside your range, like:
=IF(COUNTA(A1:Z1)=0,2,1) and fill down, then sort on this column -- puts the
blanks at the bottom (they have the "2")
Bob Umlas
Excel MVP
"Saxman" wrote in message
...
If there are a number of lines on a worksheet that are blank, can they
be deleted in one operation?
TIA
|