word wrap cutting off text

M

Matt

Hi folks,
I have a file in 2003 updated with some cells containing a lot of text. I
have it set to word wrap and I have double clicked margins as well. BUT, the
text is getting cut off still and I cannot see the entire body of text at
this point. The last sentence and a half is cut off. All things are set to
maximum short of dragging the cell way out. Anyone know how to set it to just
display the entire contents of the cell? Thanks!
Matt
 
D

Dave Peterson

You can add alt-enters to force new lines within the cell every 80-100
characters and you may be able to see more of your text.
 
L

Lori

Select the text/column/row ....go to the Format menu, select Row & then
Autofit or you can widen the row manually.
 
M

Matt

Hi Lori,

I autofit the cell but it actually cut short the content more so. Basically,
if I could make it fit vertically instead of horizontally, that would be
preferable. I tried column autofit but that didn't change anything. Thanks!
 
M

Matt

Thanks for the reply Dave! But isn't the idea behind word wrap to make that
unnecessary? Is it just to a certain point of amount of content that word
wrap does this? It seems to want to fit more into the cell if I manually
enlarge the cell horizontally. If I could get the content to enlarge
vertically that would be the goal. If I do the same vertically nothing
changes on the text. There is just more space at the bottom is all. Thanks
again!
 
D

Dave Peterson

I'm sure that's the idea, but sometimes things don't work the way you (and I)
want.

If you look at excel's help, you'll see that MS only documents that you can see
about 1000 characters in the cell.

Feature
Length of cell contents (text)

Maximum limit
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar.

So if you believe the intent (as documented in the Help system), then you won't
be happy at all.
 
M

Matt

Actually Dave, that is the best answer to give me because this person can
stop bugging me when I tell them why they cannot do it. Thanks man !!!!
 

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

Similar Threads

Wrapping and Anchors 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cannot wrap text around an image 1
Problem with printing a word document containing a table 0
Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Footnote references on one page, footnote text on the next 5
Problem with MS Word paragraph and character styles: format getting messed up 2

Top