Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rich20
 
Posts: n/a
Default 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   Report Post  
Barb Reinhardt
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default 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   Report Post  
Wildcat
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Borders with aligned text pablo bellissimo Excel Discussion (Misc queries) 1 May 5th 05 06:00 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
How do I rotate a text box Kent Charts and Charting in Excel 2 December 17th 04 01:13 AM
How I do I rotate text in an excel cell? The rotate commands is g. MickG Excel Discussion (Misc queries) 3 December 13th 04 09:14 PM


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"