View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
oli merge oli merge is offline
external usenet poster
 
Posts: 50
Default Getting rid of thousands of rows Excel 2002

Do you mean you have lots of blank rows on your recipient list in Word?

I get that problem somtimes, its because Excel gets confused about where the
true end of the data is if you once had something in a cell and then deleted
it.

A solution can be found he
http://articles.techrepublic.com.com...1-6135485.html

but personally, I just put in only the correct amount of paper/ labels and
then just cancel the print job once it starts merging the blank rows. (lazy i
know).

Also, you could cut and paste the just the data you need onto a brand new
sheet which hasnt got problem.

hope that helps.

"Northern Lights" wrote:

Hi
I have an excel 2002 spreadsheet set up by someone else which contains
thousands (likely the max) of rows. I am trying to merge into word using
this sheet and it takes forever and causes problems editing the merge. How
can I remove the extra rows? I have seen suggestions to select, delete rows
and save the document but the rows are not removed. It is extremely
irritating!!!!

Thanks.