Split a cell diagonally Solved

Question

Hello,

I have created a table with distances on the x-axis and speeds on the y-axis. In the cells of the table, I have the time it takes to cover 100 meters at 15 km/h.

In the top left corner of my table, I would like to create a cell that is split diagonally with "speed in km/h" in the lower part and "distance" in the upper part to explain what the numbers represent.

How can I create this cell? It must be quite simple, but I'm stuck.

Thank you for your help.

Lemalien · Accepted Answer

Lemalien - Dec 20, 2010 at 2:23 PM
Hello, is it too late? I have a tip: select the cell in question, right-click on it, choose "format cell," and in the window that opens, select "border," and you will see the possible outlines including "diagonal line" which will allow you to split the cell in two diagonally. Enter the first text and create a new line (in the same cell) with ALT + Enter, and then enter the second text. Then place each of the two texts on either side of the diagonal line using the "Alignment" option in the same window.

EminoMeneko · Answer

And with what software?

Raymond PENTIER · Answer

Hello.  "This must be really simple but I'm stuck". No, it's not simple at all, because you want to divert Excel from its logic of operation: One cell = one entry!  A possible "workaround": 1) Enter ' ..................... distance speed in km/h (the . are spaces) 2) place yourself between "distance" and "speed" and press [alt]+[Enter] to force a line break within the cell 3) go to cell format/alignment/wrap text 3) go to cell format/border and choose the last pictogram [\] &#9658; this solution doubles the height of the row  Another "workaround": 1) Enter "distance" in A1 and "speed" in A2 2) Right alignment  for A1 3) Insert a line from the top left corner of A1 to the bottom right corner of A2 4) Do not put a border between A1 and A2 &#9658; this solution gives 2 lines at the top of the table  https://www.cjoint.com/?ccd4DcE5l0 &#9658; Conclusion: not recommended! -- Retirement is great! Especially in the Caribbean... :-)&#9787; Raymond &#9794;

Raymond PENTIER · Answer

Hello nemotri.  Glad you managed to sort things out.  There’s no mistake, it's indeed cells A1 and A2 I'm talking about; and I even point out that the drawback of this workaround is that it adds an unnecessary row at the top of the table. When you use A1 and B2, you worsen the situation by also creating an unnecessary column to the left of the table.  Read my instructions carefully and follow them closely; you’ll see what it leads to; by the way, I had attached a file for you to see the result and choose between the two methods... -- Retirement is great! Especially in the West Indies... :-) &#9787; Raymond &#9794;

Raymond PENTIER · Answer

... Then place each of the two texts on either side of the slanted line using the "Alignment" option in the same window.  No; that's impossible!  -- Retirement is great! Especially in the Caribbean ... :-) &#9787; Raymond &#9794;

Albert · Answer

Hello  It is possible artificially with centered alignment, centered as long as the text is very short, otherwise, of course, it goes to the other side of the slash.

Vaucluse · Answer

Hello
maybe a little trick, right?

place the 1st title (the one in the lines) at the top right of the cell
select the cell and:
insert / Shapes / choose the right triangle
draw it in the cell while holding the alt key down;
The triangle fits perfectly in the cell, the hypotenuse being the diagonal.
place the second title inside the triangle as text... we can even change the colors between the cell and the triangle.
we can rotate the triangle to modify the orientation, etc....
as a precaution: right-click on the shape and size and properties / properties
check: move and size with shape;
Thus the triangle stays attached to the cell

Best regards

--
Let's ask ourselves if we're not the only ones who understand what we're explaining?

Split a cell diagonally

7 answers

How to unsubscribe from jm plan cul

Edit ad on leboncoin for free

Commun.file_upload.maxsize

Problem opening modal window from another page

Thursday modification test title number 3

How to change sources on a grundig universal remote?

Adobe reader saves a file instead of printing

Is tokyvideo a reliable site? what are your opinions?

Locate a turned-off phone with its imei.

I accidentally liked a photo on instagram.