Thread: Rotating Text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Rotating Text

Hi Stan

What version of Excel are you using?
I don't get any problem with the 2 sample texts you provided, In Xl2003 or
XL2007.
At 90 degree no problem at all.
At 45 degree, Ok once borders added to cells.
--
Regards
Roger Govier

"StanTheManII" wrote in message
...
I have tried everything, even our excel expert is stumped. I think its a
bug, and should probably report it to microsoft. Just try a 17 (3 word)
text
"the cat sat on the mat and the dog ran over the cat with a car" or try a
text "Compressed Available Dispicable incapable destitute overwhelming"
see
how the wrap is incorrect. You'll see the words missing. We've tried
several computers now an all exhibit the same problem.


"Roger Govier" wrote:

Hi Stan

What happens if you make the row deeper?
Do you mean rotating by 90 degrees, or 45 degrees?
I have seldom had problems with 90 degree rotation.
With 45 degree, apply borders to the cells and that usually helps.

--
Regards
Roger Govier

"StanTheManII" wrote in message
...
I have orientated (rotated) text by the orientation dial by 90 degrees.
The
headings I have in these cells are about 30 letters long. When I
rotate
the
text is causes the text to run into each other. Words later in the
text
appear within the previous text in the cell and is undreadable. It
also
trunkates the words at the "word wrap" area removing 2 letters of each
word
at the word wrap zone. I am using Arial 10, athough I've tried other
fonts.
Using long words exaserbates the problem.

Any ideas.