Excel Cell doesn't show all text

G

Guest

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!
 
G

Guest

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.
 

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