how can I split a single cell diagonally in Excel 2000

F

Forrest

Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?
 
J

John Mansfield

Forrest,

As far as I know, you can not split a cell diagonally so that it can contain
2 pieces of information. However, you can merge cells which might give you
the effect that you want. To do so, go to the standard toolbar and hit
Format -> Cells -> Alignment Tab -> Text Control and work with the merged
cells option.
 
D

Dave Peterson

First, try not to do it. It gets more difficult to do stuff based on what's in
the top left corner vs what's in the bottom right corner.

But when I have to do this (and this looks awful!), I type my first value,
alt-enter, some spaces and the second value.

Add a diagonal border and with a little fiddling, it might pass.
 
Top