SOLVED

Excel Cell Borders alignment

%3CLINGO-SUB%20id%3D%22lingo-sub-1445849%22%20slang%3D%22en-US%22%3EExcel%20Cell%20Borders%20alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445849%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20spreadsheet%20has%20borders%20around%20the%20cells%20but%20when%20I%20format%20the%20text%20orientation%20to%20diagonal%20the%20vertical%20borders%20also%20show%20diagonal%20and%20the%20whole%20cell%20crosses%20over%20into%20the%20next%20cell.%20How%20do%20I%20keep%20the%20vertical%20borders%20vertical%20and%20not%20diagonal.%20This%20never%20used%20to%20happen%20in%20older%20versions%20of%20excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445973%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Cell%20Borders%20alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691253%22%20target%3D%22_blank%22%3E%40DeanBronco%3C%2FA%3E%26nbsp%3BSome%20research%20on%20the%20web%20tells%20me%20that%20this%20already%20happened%20in%20Excel%202003.%20I%20guess%20it%20is%20to%20be%20considered%20a%20%3CSTRONG%3Efeature%3C%2FSTRONG%3E%20of%20working%20with%20borders.%20I%20found%20two-work%20arounds%20on-line%20in%20very%20old%20articles%20but%20neither%20of%20them%20can%20be%20considered%20%22good%20practice%22.%20Attached%20a%20file%20with%20the%20work-arounds%20applied.%20Alternatively%2C%20reconsider%20the%20use%20of%20angled%20texts%20with%20borders.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-07%20at%2008.19.48.png%22%20style%3D%22width%3A%20203px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197076i44B1EAF9F93BCD52%2Fimage-dimensions%2F203x306%3Fv%3D1.0%22%20width%3D%22203%22%20height%3D%22306%22%20title%3D%22Screenshot%202020-06-07%20at%2008.19.48.png%22%20alt%3D%22Screenshot%202020-06-07%20at%2008.19.48.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447782%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Cell%20Borders%20alignment%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447782%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20you%20looking%20into%20this%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20for%20what%20I%20want%20your%20option%203%20using%20merged%20cells%20works%20best%20for%20what%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 keep the vertical borders vertical and not diagonal. This never used to happen in older versions of excel.

2 Replies
Highlighted
Best Response confirmed by DeanBronco (New Contributor)
Solution

@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.

Screenshot 2020-06-07 at 08.19.48.png

Highlighted

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.