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