| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Highlight column headings when cursor is in a cell. | Excel Discussion (Misc queries) | |||
Linear Mode
