copying to Word and row height

Giganews Newsgroups
Subject: copying to Word and row height
Posted by:  Jeff@nospam.invalid (Jeff@nospam.invalid)
Date: Tue, 25 Jan 2011

Question 1
I have an XL 2002 spreadsheet where the rows are very tall even though
the text does not fill them entirely. I've checked and there are no
extra spaces or blank lines at the end. The cells are formatted as
"Vertical=top" and "wrap text".

Is there a way to change this?

Question 2
I also need to transfer the contents of certain cells to a Word document
so I can print as a table. But when I copy and paste from XL to Word I
get the same problem: very tall rows that fill a page each.  All I need
is to transfer the _text or numbers_ in certain XL cells into a table in
Word, so that each cell becomes a Word table cell but not filling an
entire page per cell. Is there a way to do that?

Thank you.