Rotating Text

[StanTheManII]

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.

 

[Roger Govier]

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.

 

[ShaneDevenshire]

How about merging the cells as well as rotating them?

 

[StanTheManII]

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]

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.

 

[StanTheManII]

I'm using 2003 (11.8211.8292) SP3. The monitor is a widescreen. It does it
on several computers! The word wrap cuts of part of the information. I
tried putting a border around it, didn't cure it.

Tnx

DavidAB

 

[Roger Govier]

Sorry Stan, I'm out of ideas.
As I said, it works fine for me.