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

G

Guest

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?
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
G

Guest

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
 
G

Gary Bateman

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format a column to be half the size of the one above it? 1
Subtotals 2
How can I get the row and column heading of my active cell highlig 2
Font size for row and column headings 2
Column Heading Error 3
Column Headings in Excel 2
Vertical to Horizontal 3
Row to Column 3

Top