In creating a table header that explains what the row and column values represent, a common approach is to use a cell with text separated by a diagonal line. This, first for me, video tutorial explains how.
For those who prefer a text explanation:
Format the cell “border” to add a diagonal from the left-top to the right-bottom (it’s one of the line choices in the Format Cells dialog box | Borders tab).
Then, type several spaces the literal Hours ALT+ENTER to create a newline in the text and then the literal Days.
Adjust the number of spaces before the literal Hours to get the desired effect.
An alternative, which is simple albeit crude, is to type Days space \ space Hours. {grin}
Very slick….I like it. Finally a practical use for diagonal border lines.
:)
MSimms
Doesn’t http://www.excelhero.com/blog/2010/06/excel-optical-illusions-week-19.html
classify as practical ?
Congrats on your first video. Well done!
This isn’t quite like splitting cells or columns. It’s a hack that is limited especially in terms of formatting. The amount of text you can add in this cell is also limited. If you want to add more text, you might have to use a text box and insert it in the cell which will make managing the table all the more difficult. Use this sparingly or only if you have the time needed to fix the formatting.