how to rotate text without rottating borders
 

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 ???

how to rotate text without rottating borders
 

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

"rich20" wrote in message
...
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 ???

how to rotate text without rottating borders
 

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

how to rotate text without rottating borders
 

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


--
Wildcat
------------------------------------------------------------------------
Wildcat's Profile: http://www.excelforum.com/member.php...o&userid=28554
View this thread: http://www.excelforum.com/showthread...hreadid=481990

how to rotate text without rottating borders
 

"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 ???

how to rotate text without rottating borders
 

You cannot do this.

You could use the drawing toolbar to fraw a rectangle around the cell and set
the background to transparent.

Set the line to 2 pts so's it stands out.


Gord Dibben MS Excel MVP

On Mon, 14 Jul 2008 06:09:02 -0700, gotu wrote:



"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 ???