Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ??? |
#2
|
|||
|
|||
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 ??? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ??? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Borders with aligned text | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I rotate a text box | Charts and Charting in Excel | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) |