copying to Word and row height

[Jeff]

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.

Jeff

 

[Liana]

Hi Jeff,
1. I usually have the opposite problem, where Excel cuts off the text
in a cell (when it's very long) so that I can't see it all. In your
case, I am assuming you have already tried "double-clicking" the row
height to get it to "autofit", and there is still lots of white
space? Are you sure there aren't any hidden columns with large
amounts of text in them which are affecting the row height? If you
want the row heights uniform (identical), you could select the entire
sheet and manually drag the row height to a more manageable height (or
use Format | Row | Height). If you increase the width of the cell
with the text, does the row height shrink at all?

2. If you have hidden columns in the Excel sheet which are dictating
the tall rows, this might also be the problem here. When I select a
single Excel cell, I can easily copy and paste it into a Word table
cell. Are you having trouble only when copying/pasting a range of
cells?

Liana