View original (French)

How to write in a cell separated by a diagonal?

Solved
mj1974 Posted messages 2003 Registration date   Status Member Last intervention   -  
mj1974 Posted messages 2003 Registration date   Status Member 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.”

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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.
    1
    1. mj1974 Posted messages 2003 Registration date   Status Member Last intervention   359
       
      Hello.
      Thank you for your help, it works.
      Have a good day.
      Best regards.
      0