Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Slanted cell borders (Excel (All))

    A friend of mine asked me to help her out. I doubt that it can be done, but I'm not much of an Excel user.
    Her boss wants her to to not only have slanted text in the first row cells, as she has now, but also to slant he cell borders. Like in the right part of attached drawing. Can that be done and if so, how to proceed?
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Slanted cell borders (Excel (All))

    Not really. You can create diagonal cell borders, and fake the effect she wants to some extent - see the screenshot below.
    But as you see, you must insert extra columns for the diagonal borders, and sometimes Excel doesn't draw borders correctly - note the gap in the upper border.
    Attached Images Attached Images

  3. #3
    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: Slanted cell borders (Excel (All))

    In addition to Hans's suggestion, another way is to decide not to use a border at all and use a trapezoid autoshape to act as a Border. Since it is only for the top row it should not be too difficult to set up after the column and row size is set

    Steve
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Slanted cell borders (Excel (All))

    Hey, that's neat! Much better than my suggestion - thanks!

  5. #5
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slanted cell borders (Excel (All))

    Thank you very much!
    Very neat trick. <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

  6. #6
    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: Slanted cell borders (Excel (All))

    Thanks,

    I will have to remember this. I did not realize it would do this automatically. This is much better than my solution.

    Steve

  7. #7
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Slanted cell borders (Excel (All))

    That's nice, thank you.

    If you put the borders onto blank cells, it doesn't look as if it's done it correctly. But when text is typed into a cell, it does exactly what you want.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts

    How to create slanted cell borders (Excel (All))

    Does the attached do what you want?
    Set the orientation of the cell alignment to the desired angle (using the Format Cell | Alignment tool) and the cell borders (when displayed) follow the same angle.
    Attached Files Attached Files

Posting Permissions

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