View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jerry AMK[_2_] Jerry AMK[_2_] is offline
external usenet poster
 
Posts: 4
Default Cell format - wrap text

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.


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Jerry AMK" wrote:

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

"Jacob Skaria" wrote:

Try ...
Select the range. FormatRow/Column/Autofit

If this post helps click Yes
---------------
Jacob Skaria


"Jerry AMK" wrote:

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