Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert row and column labels into a single cell
I would like to have my rows and columns labels neatly inserted in one single
top left hand cell, further divided diagonally. Is there any quick way to do it. How to ensure the text is easily editable within the two parts of the cell. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert row and column labels into a single cell
A cell cannot have two parts.
About the only thing you can do is add a diagonal border then manually space your text on either side of the border.. Quick...........no Fiddly..........yes Gord Dibben MS Excel MVP On Fri, 22 Jan 2010 14:47:02 -0800, Good Shape <Good wrote: I would like to have my rows and columns labels neatly inserted in one single top left hand cell, further divided diagonally. Is there any quick way to do it. How to ensure the text is easily editable within the two parts of the cell. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert row and column labels into a single cell
I don't know of a way to divide a cell diagonally. But you could put "Col
Label / Row Label" in A1, and have the text wrap so that it's displayed on two lines. Best solution that occurrs to me on the spur of the moment. --- "Good Shape" wrote: I would like to have my rows and columns labels neatly inserted in one single top left hand cell, further divided diagonally. Is there any quick way to do it. How to ensure the text is easily editable within the two parts of the cell. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to insert row and column labels into a single cell
Good Shape wrote:
I would like to have my rows and columns labels neatly inserted in one single top left hand cell, further divided diagonally. Is there any quick way to do it. How to ensure the text is easily editable within the two parts of the cell. Thank you. The really quick way is to use two cells: A1 and B2. Appearance may not be exactly what you want but I'd suggest left aligning A1 and right aligning B2. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert a single quote on every cell in a column to make . | Excel Discussion (Misc queries) | |||
Adding cell labels to multiple single cells | Excel Discussion (Misc queries) | |||
Insert 5 rows between existing values in a single column 1 | Excel Worksheet Functions | |||
From single cell variables to a single column serie | New Users to Excel | |||
how do I insert column headings or labels without using a row? | Excel Discussion (Misc queries) |