how to diag. split a cell for two headings (for row AND column)?
 

Is it possible to diagonally split a cell to place two headings in one cell -
one for the row heading and the other for the column heading?

how to diag. split a cell for two headings (for row AND column)?
 

Not possible to physically split a cell into two or more parts.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 20:31:02 -0700, beckymspt
wrote:

Is it possible to diagonally split a cell to place two headings in one cell -
one for the row heading and the other for the column heading?

how to diag. split a cell for two headings (for row AND column
 

you can draw a diagonal line across the cell align the data in the centre of
the cel vertically and with judiciuos use of spaces palce your data either
side of the diagonal line.It only looks like two sets of data you cant really
do anything with that cell
--
paul

remove nospam for email addy!



"Gord Dibben" wrote:

Not possible to physically split a cell into two or more parts.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 20:31:02 -0700, beckymspt
wrote:

Is it possible to diagonally split a cell to place two headings in one cell -
one for the row heading and the other for the column heading?

how to diag. split a cell for two headings (for row AND column
 

Gary wrote: I was looking to split and colour one half of a cell diagonally
as I was using for a Gantt Chart with overlapping activities. From what you
say there is no way of doing this with individual cells? May be something for
Microsoft to look at in development!

"paul" wrote:

you can draw a diagonal line across the cell align the data in the centre of
the cel vertically and with judiciuos use of spaces palce your data either
side of the diagonal line.It only looks like two sets of data you cant really
do anything with that cell
--
paul

remove nospam for email addy!



"Gord Dibben" wrote:

Not possible to physically split a cell into two or more parts.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 20:31:02 -0700, beckymspt
wrote:

Is it possible to diagonally split a cell to place two headings in one cell -
one for the row heading and the other for the column heading?