Create a header cell with text separated by a diagonal line
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!