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

argixu · 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 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.