Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: creating angled lines for column 'titles'

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    San Luis Obispo, CA
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Rather hard to describe well what I need... I'm creating a table with column widths of 10 or so. I need to label each column head with several words (about 20 character max) which will not fit on the narrow width columns. I need to know how to create angled lines at the head of each column on which text can be typed at the same angle, on or above the angled lines. Then the text I need will fit in the width I want, and look neat as well. Simple question I think, I'm just not as well-versed in Excel as I would like! Thanks!!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Select your headers, choose the Format | Cells... menu command (or Control+1), click on the Alignment tab, drag the orientation dial to the desired position or enter the desired degree (e.g., 45) value. Click on the Borders tab and apply them if desired.

    [ This Message was edited by: Mark W. on 2002-04-24 15:38 ]

  3. #3
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For the lines, you can either choose to "Underline" the text (U) (not cell underline border, although a complete cell border seems to angle...) or draw in your very own lines. See Insert->Picture->AutoShapes. Click on the left-most icon and you're ready for custom lines.

    _________________
    Cheers, NateO
    "Me no are no nice guy."

    [ This Message was edited by: NateO on 2002-04-24 15:49 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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