Split Cell Diagonally in Excel & Include Text | Format With Two Colours

In this video I demonstrate how to split a cell using a diagonal line and how to write text above and below the diagonal. This method is useful if you want to includes two headers in the top left-hand corner of a table: one for your column headings and one for your row headings.

I also demonstrate how to split a cell diagonally using colour, also including text (headers) in each part of the cell.

Table of Contents:

00:00 - Introduction
00:16 - Split a cell diagonally using a diagonal line
01:30 - Split a cell diagonally using colour
------------------------

[bhar]

That's a neat trick, I hadn't thought of that before. I could see it potentially coming in handy.

[slaveofjesus]

But is there any way to make that cell actually two separate cells? That would allow us to then point a math formula to other cells and have half that cell block update independently of the other half of that cell block. Maybe impossible to do.