split excel cell diagonally Solved/Closed

Question

Hello, to fill a schedule, I would like to type the words FRENCH and ENGLISH in the same cell separated by a diagonal. If I click on border and select diagonal border, my cell is correctly divided in two, but the two words are either above or below the diagonal. Do you have a solution to propose? Thank you in advance and best regards.

Vaucluse · Accepted Answer

For those who want to have fun:  *Drawing Toolbar _Select the cell to fill _Select AutoShape / Basic Shape / Right Triangle _Draw the triangle in the cell while holding the alt key to fit it to the cell (thanks m@rina)  *Select the drawn shape, green handle, 1/2 turn in the cell  *Repeat the same initial operation to create a lower triangle  *Check the type of shapes: _/Right-click on the shape / Properties / Move and size with cells  *Select right-click: add text _Write in the shape.  *Advantage for a presentation: the two areas can be of different colors: Right-click on the shape / Format / ... / Fill and Line  Have fun BCRDLMNT   -- Science without conscience is but the ruin of the soul

eriiic · Answer

Good evening,

The separation is only visual, you still only have a single cell.
A solution (but annoying...) is to take 4 cells in a square for each box, like A1:B2
Frame the outline, select A2 and B1 and place the diagonals inside.
Write in A1 left-aligned
write in B2 right-aligned

eric

Vaucluse · Answer

Good evening everyone
There's another one, equally frustrating...
It's about writing on two lines in the cell and shifting the line in the tip with spaces
Anyway, to type on two lines, instead of hitting enter, press alt+enter, you stay in the cell
Good luck

BCRDLMNT
--
Science without conscience is but the ruin of the soul

xkristi · Answer

Good evening!  We can also use the line in the drawing toolbar but we still only have one cell... -- xkristi Life is more...

Anonymous user · Answer

Hello, It's sporty but excellent! I'm keeping it because I'll use it often. We're players from Vaucluse, right? -- Argitxu

Vaucluse · Answer

Especially on Sundays.... ;-) BCRDLMNT -- Science without conscience is but the ruin of the Soul

LittleGoldorak · Answer

Thank you all, as I am "a bit more than a beginner, but far from being an experienced user," I will stick with the easiest solution. Thank you again and best regards.

Beno · Answer

Hello,

I know I'm completely out of sync, but for me the simplest solution is to define (using the drawing toolbar) two text areas in a cell that has been split in two beforehand, either by a line or by an internal diagonal via the Cell menu..., Borders. There you go!

Split excel cell diagonally

8 answers

No tone on my redmi note 13 pro 5g

Be able to use google play apps on huawei

Search for music season 9 episode 5 part 2

Texture issues in enshrouded

Comment blocking comments and republication bell

Trail camera requires a code

Coralisle 2 on mac loads into a blank screen

Save on excel

This site is unreachable

Windows 10 to 11 + bios change