Thread: Rotating Text
View Single Post
  #7   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

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

--
Regards
Roger Govier

"StanTheManII" wrote in message
...
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" wrote:

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.