Forum Discussion

DeanBronco's avatar
DeanBronco
Copper Contributor
Jun 07, 2020
Solved

Excel Cell Borders alignment

My spreadsheet has borders around the cells but when I format the text orientation to diagonal the vertical borders also show diagonal and the whole cell crosses over into the next cell. How do I kee...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 07, 2020

    DeanBronco Some research on the web tells me that this already happened in Excel 2003. I guess it is to be considered a feature of working with borders. I found two-work arounds on-line in very old articles but neither of them can be considered "good practice". Attached a file with the work-arounds applied. Alternatively, reconsider the use of angled texts with borders.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 07, 2020

DeanBronco Some research on the web tells me that this already happened in Excel 2003. I guess it is to be considered a feature of working with borders. I found two-work arounds on-line in very old articles but neither of them can be considered "good practice". Attached a file with the work-arounds applied. Alternatively, reconsider the use of angled texts with borders.

  • DeanBronco's avatar
    DeanBronco
    Copper Contributor
    Jun 08, 2020

    Thanks Riny_van_Eekelen 

     

    I appreciate you looking into this for me.

     

    I think for what I want your option 3 using merged cells works best for what I want.

     

     

Resources