Perhaps. If the text requires 5 rows and you have selected only 3, Excel
will tell you that. If there's no data below, you can simply say to to
proceed with the paste.

If you want to automate the whole thing, you'll have to write a macro.

wrote in message
ups.com...
Thanks for that tip. If I have multiple paragraphs in word...is there
another trick to avoid having to count how many rows there will be in
excel. I'd like to just copy and paste text from word to excel... and
have some automated process where rows are created or adjusted wihout
having to manually repeat steps.