How do I remove numerous blank rows from Excel spreadsheet?

J

JP6262AMY

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!
 
R

Ray A

one way
highlight the range press F5>click special...>click the radio button
"Blanks">OK Now press ctrl+- and delete rows
 
P

Paul Black

Ray,

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

Thanks.
All the Best.
Paul
 
D

Dave Peterson

Another option...

Select your data and sort it by a column that always has data--except for the
rows that are blank.
 
Top