How do I remove numerous blank rows from Excel spreadsheet?
 

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!

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!

Thanks, Ray! That will really save me a lot of work!!

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

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!

Another option...

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

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!

--

Dave Peterson