Cell split with diagonal.

[RainyDay]

I am trying to put a diagonal into a cell with a value in the top left corner
and a value in the bottom right corner. My space is limited on a spreadsheet
to add this in. Any ideas?

 

[John C]

You can't. Cells don't split diagonally. You can make it 'appear' as such,
but you need 4 cells.
I.E.: Type values in A1 and B2, Format cells A2 & B1 with diagonal border
going from lower left to upper right, Select A1:B2, and put a border around
the selection, Turn off gridlines. Make the columns as narrow as possible.
It 'looks' like you want, but it isn't really.

 

[Ken Johnson]

I am trying to put a diagonal into a cell with a value in the top left corner
and a value in the bottom right corner.  My space is limited on a spreadsheet
to add this in.  Any ideas?

Use Alt+Enter to vertically separate your top and bottom values.
Make the cell's vertical alignment Justify or Distributed and
horizontal alignment Right (Indent) with zero indent.
Use non-breaking spaces immediately to the right of the top label to
shift it to the left side of the cell. The number of non-breaking
spaces you use depends on the width of the column.
To get non-breaking spaces either go Insert|Symbol|”Special
Characters” tab|non-breaking space|Insert|Cancel
or hold down the Alt key while you type 0160 on the number key pad. To
enter more than one non-breaking space release the Alt key after
entering each non-breaking space.

Just curious, if this cell is in the top-left corner of a table
wouldn't it be better to have the diagonal going the other way ie top-
left to bottom-right?
If this is so then horizontal alignment would be Left and non-breaking
spaces would be inserted to the left of the top value.
Maybe this isn't the case though.

Ken Johnson