Excel Cell doesn't show all text

nhis problem is very irritating. I an answering a survey that was formatted
by an outside company (I can't contact the author of the spreadsheet).

The answers should go into a cell, and because we answer these surveys a
lot, the amswers for them are already in a Word document. It should be a
simple case of cutting the text sections from the Word doc and pasting them
into the Excel cell.

Retyping the sections into the cells would be very time consuming, and also
I am unaware of how to enter in paragrpahs into Excel cells.

The problem: If there are "too many words" in the Word doc sections, Excel
cuts them off. Now when you select the cell, the entire text appears in the
drop down bar, but no matter what formatting I try (Left, Justify, General,
Center, Top, Bottom, Merge, Wrap, etc). -- or, no matter what size I make the
cell itself, in both the view mode AND in printing the document-- the words
are cut off after a certain point.

Any suggestions on how to be able to see the entire text within the cell?

Thanks!

This problem can be fixed by inserting forced returns (ALT-ENTER) in the
body of the text. If properly placed, the text will be both visible in the
cell and in printed format.
--
Gary''s Student


"Need 2 Know!" wrote:

> nhis problem is very irritating. I an answering a survey that was formatted
> by an outside company (I can't contact the author of the spreadsheet).
>
> The answers should go into a cell, and because we answer these surveys a
> lot, the amswers for them are already in a Word document. It should be a
> simple case of cutting the text sections from the Word doc and pasting them
> into the Excel cell.
>
> Retyping the sections into the cells would be very time consuming, and also
> I am unaware of how to enter in paragrpahs into Excel cells.
>
> The problem: If there are "too many words" in the Word doc sections, Excel
> cuts them off. Now when you select the cell, the entire text appears in the
> drop down bar, but no matter what formatting I try (Left, Justify, General,
> Center, Top, Bottom, Merge, Wrap, etc). -- or, no matter what size I make the
> cell itself, in both the view mode AND in printing the document-- the words
> are cut off after a certain point.
>
> Any suggestions on how to be able to see the entire text within the cell?
>
> Thanks!