How to write in a cell separated by a diagonal?
Solved
mj1974
Posted messages
2003
Registration date
Status
Membre
Last intervention
-
mj1974 Posted messages 2003 Registration date Status Membre Last intervention -
mj1974 Posted messages 2003 Registration date Status Membre Last intervention -
Hello,
I have divided a cell with a diagonal line.
I would like to write on each side, at the top left and at the bottom right.
Like the attached link for "periods and fruits" (but the other way around).
https://www.01net.com/astuces/excel-remplir-une-cellule-en-diagonale-586751.html
I can write at the top left (easy) but not on the other side (so at the bottom right).
How can I do this, please?
Thank you.
Best regards.
Configuration: Windows 7 / Firefox 40.0
“I can accept failure, everyone fails at something. But I can't accept not trying.”
I have divided a cell with a diagonal line.
I would like to write on each side, at the top left and at the bottom right.
Like the attached link for "periods and fruits" (but the other way around).
https://www.01net.com/astuces/excel-remplir-une-cellule-en-diagonale-586751.html
I can write at the top left (easy) but not on the other side (so at the bottom right).
How can I do this, please?
Thank you.
Best regards.
Configuration: Windows 7 / Firefox 40.0
“I can accept failure, everyone fails at something. But I can't accept not trying.”
1 réponse
Good evening
a little trick:
write in the cell and position it in a corner with the alignment
insert a shape (right triangle) into the cell
so that the shape fits exactly to the cell:
___select the shape from the insert/menu shape
___go to the cell, hold down the alt key and draw the shape which will automatically fit to the cell
___format the shape with no outline and no fill color (by right-clicking on the shape)
___adjust the margins / format and "text box")
___Place the second text inside the shape.
*
if you need to modify the formats afterwards, right-click on the shape / properties and ensure that the option: move and size with cells is checked
sincerely
To err is human, to persist is diabolical.
a little trick:
write in the cell and position it in a corner with the alignment
insert a shape (right triangle) into the cell
so that the shape fits exactly to the cell:
___select the shape from the insert/menu shape
___go to the cell, hold down the alt key and draw the shape which will automatically fit to the cell
___format the shape with no outline and no fill color (by right-clicking on the shape)
___adjust the margins / format and "text box")
___Place the second text inside the shape.
*
if you need to modify the formats afterwards, right-click on the shape / properties and ensure that the option: move and size with cells is checked
sincerely
To err is human, to persist is diabolical.
Thank you for your help, it works.
Have a good day.
Best regards.