copying to Word and row height

J

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top