How do I split a cell diagonally?

  • Thread starter Thread starter Guest
  • Start date Start date
You can't really do this. You can put a diagonal line through a
cell. Go to the Format menu, choose Cell, then the Borders tab.
Click the diagonal line button. This will display a diagonal
line in the cell, but will have no effect on splitting the cell's
text between the two regions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Depending on what you want in there though, you may be able to achieve that
kind of effect, eg

Format the cell as Chip described, type 'ab' hit ALT+ENTER, type few spaces
and then type 'cd'

Get the spacing right and you will have the appearance of a split cell.
Useless for data that needs to be numeric, but if it functions as a column
and row header then it works fine. Not an ideal choice to me as you can't
refer simply to each value (though it can be done), but it may be what you
are looking for.
 
You can "fake" doing this by using drawing objects (triangles), one on top
the other.........they will accept text and can be colored to
suit.........lthough only really usefull as like a column header,
etc...............

Vaya con Dios,
Chuck, CABGx3
 

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

Back
Top