Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    text boxes III ('97, SR-2)

    Is there any way to create a non-rectangular text box?
    (I need a triangular one.)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: text boxes III ('97, SR-2)

    Does an Autoshape triangle serve your needs? Autoshapes are on the drawing toolbar and you can add text to them.

    Steve

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: text boxes III ('97, SR-2)

    You can also make those Autoshapes get their text indirectly from a cell: after selecting the shape, type =A2 in the formula bar and the text from cell A2 will appear in the shape. Unfortunately, the actual shape of the text within the triangle is only rectangular, but if you center justify, you can make it look triangular. I've attached an example. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text boxes III ('97, SR-2)

    >>Autoshapes are on the drawing toolbar and you can add text to them.

    How, Steve? Sammy's method works ok with '97 (but no 'paste special, values' option so the source cell mustn't be cleared) but how type in the text directly, as in a regular text box?
    My workaround in the past has been a regular text box, no lines and transparent, grouped on top of the fancy shape. Your way would be good.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: text boxes III ('97, SR-2)

    Insert the autoshape
    Right -click on it and choose - "Add text" from the menu

    Steve

  6. #6
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text boxes III ('97, SR-2)

    Thanks, Steve.
    Moral = when in doubt, right-click and see what's offered?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •