How to insert row and column labels into a single cell

  • Thread starter Thread starter Good Shape
  • Start date Start date
G

Good Shape

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.
 
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
 
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 said:
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.
Click to expand...

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
 
Back
Top