how to rotate text without rottating borders

[rich20]

i'm trying to angle (rotate text in exel) it ofcourse rotates fine bot then i
put border on that cel the border is also rotated how to rotate text without
rotatting border ???

[Barb Reinhardt]

What kind of border do you have on the cell? I don't understand the issue.

"rich20" <[email protected]> wrote in message
news:[email protected]...
> i'm trying to angle (rotate text in exel) it ofcourse rotates fine bot
> then i
> put border on that cel the border is also rotated how to rotate text
> without
> rotatting border ???

[Debra Dalgleish]

You can't change the text alignment in a cell, without affecting the
borders.

You could use the drawing tools to create borders, by drawing rectangles
around the cells, with no fill colour.

rich20 wrote:
> i'm trying to angle (rotate text in exel) it ofcourse rotates fine bot then i
> put border on that cel the border is also rotated how to rotate text without
> rotatting border ???


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Wildcat]

Exactly, Deb.

The good thing is you can still select the cell and edit the contents, change the direction, etc.

And, if you carefully placed the drawing object exactly on the 'normal' cell border, it acts like a cell border -- when you resize the row or column.. the drawing object (rectangle/square) resizes too! (At least in Office2003) Whereas if you put the drawing object inside the physical cell border it won't move or resize. Try aligning only one or two edges of the drawing object with one or more cell borders, too. The object will resize in one direction, but not others.

~ wC

[rockabout]

I have found that you can merge the cell with an adjacent cell and the border will no longer rotate to the same angle as the text.