Excel wrap text problem

S

Stack

Has anyone else seen this??

When I use the "wrap text" format for a cell, instead of wrapping to a new line the text is wrapped to the same line... I tried changing the font properties, cell proerties and even different types of data, but it continues to overlap itself... Any ideas???
 
K

Ken Wright

Select the row and do Format / Row / Autofit. Any manual setting will override
the wrap feature.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Stack said:
Has anyone else seen this???

When I use the "wrap text" format for a cell, instead of wrapping to a new
Click to expand...
line the text is wrapped to the same line... I tried changing the font
properties, cell proerties and even different types of data, but it continues to
overlap itself... Any ideas???
 
S

Stack

I tried "Format | Row | Autofit" and "Format | Column | Autofit"... as well as changing the text formatting from "General" to "Text" to "Number" and back to "General" again. I have changed font size, column width, alignment properties, and every other modification I could think of... but it still overlaps the text. Even when I press Alt+Enter and get multiple lines in the formula bar, the cell continues to display the text overlapped on top of itself

I am running Windows XP Professional and originally had Excel 97 installed... but after having this problem and not finding a solution, I upgraded to Excell 2002... unfortunatley it didn't help and I'm right back to where I started. Any ideas would be great!!

Thanks

----- Ken Wright wrote: ----

Select the row and do Format / Row / Autofit. Any manual setting will overrid
the wrap feature

--
Regard
Ken....................... Microsoft MVP - Exce
Sys Spec - Win XP Pro / XL 97/00/02/0

---------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-
---------------------------------------------------------------------------



Stack said:
Has anyone else seen this??
Click to expand...
line the text is wrapped to the same line... I tried changing the fon
properties, cell proerties and even different types of data, but it continues t
overlap itself... Any ideas??
 
Top