Home |
Search |
Today's Posts |
#1
|
|||
|
|||
split cells
How do I split a cell diagonally and put data on both sides?
|
#2
|
|||
|
|||
You may be able to get that look by typing a value and hitting alt-enter (to
force a new line within the cell) (and then add some spaces to the top or bottom depending on the direction of the diagonal). Format|Cells|border tab is where you could draw the diagonal. But once you do this, it may look nice(?), but it'll become really awful to extract stuff you need for other formulas. (I wouldn't do it.) mwuttke wrote: How do I split a cell diagonally and put data on both sides? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |