Ray,

What a GREAT Way of Deleting Blank Rows, I will Certainly be Using that
in Future.

Thanks.
All the Best.
Paul



Ray A wrote:
one way
highlight the range press F5click special...click the radio button
"Blanks"OK Now press ctrl+- and delete rows

"JP6262AMY" wrote:

Data is imported from an external source and contains numerous blank rows
within the data. How can I remove the blank rows without having to select
each one? There are sometimes hundreds of them. Thanks!