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!