how can I split a single cell diagonally in Excel 2000
 

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

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.

----
Regards,
John Mansfield
http://www.pdbook.com

"Forrest" wrote:

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

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.

Forrest wrote:

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

--

Dave Peterson