Cell format - wrap text

[Jerry AMK]

Hi,
I have cell filled with many numbers (4 digits to 10 digits) and the cell
format is general wrap text, but when view/print the content not showing all
the numbers, even after increase the row height.
I am using Excel 2002.
Any setting I missed out or is it limited to certain maximum charactes in
one cell?
Thanks,
Jerry

 

[Jerry AMK]

Thanks, but it is not working. The row decreased but some of the numbers are
still "hiding"

 

[Jacob Skaria]

I hope you have selected all rows and did this. OK try this

--Select All. (Ctrl+A).
--Point the cursor towards row header (where the rows are numbered)
--When you bring the cursor between row header 1 and 2; the cursor will
change to a + sign.
--Double click.

If this post helps click Yes

 

[Gord Dibben]

You say "many" numbers in a cell.

Then you say "4 digits to 10 digits"

That doesn't seem like many to me and would not require the use of wrap
text.

Have you misstated what the cell contains?

Maybe many groups of numbers with 4 to 10 digits in the cell?


Gord Dibben MS Excel MVP


On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry

 

[Jerry AMK]

Thank you, but is still the same. I set the row was higher try to give some
space but if I double click it will shrink back....I understand I can use
Alt+Enter to force break the characters, but it will take some time for
adjusting the view.

Thanks again Jacob.

 

[Jerry AMK]

Sorry, maybe I describe it wrongly.
I have a cell filled with group of invoice numbers (i.e: 7171, 82426,
827782133007116, 2133007238, ...) and it maybe more than 1000 characters in
that cell. I saw your earlier post for other's similar questions and you
mentioned about 1024 character limitation. Maybe I have to accept this
condition?
I also try Alt+Enter but it good if only for few times.

Thank you,
Jerry

 

[Gord Dibben]

Jerry

First...............A worksheet has many cells. Why are you pounding so
much into one cell? You have eliminated any use of sorting or filtering or
just about any other function.

Second.................the Alt + Enter should work if you place one every
100 chars.

Third................are you dealing with merged cells? These will disable
the row autofit and must be dealt with manually or through VBA code.

Maybe a textbox would serve you better if you need all that info in one
cell.


Gord

 

[Jerry AMK]

Thanks Gord,

I may have to distribute the content to few cells.

Jerry