Ever have a hard time figuring out what to label the top left cell in your data table? It can feel like being stuck between a rock and a hard place. Should you label it as the column header or the row header? Well, porque no los dos?
You can label the column and the row in this one cell by creating a split cell, which does exactly what it sounds like: It allows you to split the cell into two parts.
To create a split cell, enter the column header first, then the row header. Next, insert a line break between the two by pressing Alt+Enter. This will move the column header to the line below the row header within the cell. Next, move the row header to the border on the right by inserting spaces in front of it.
Now it’s time to add the diagonal line to split the cell. To do this, click the dialog box launcher in the bottom right-hand corner of the Alignment group to open the Format Cells dialog box. Move on over to the Border tab, select the downward diagonal line, hit OK, and you’ve successfully split the cell!
Honestly, it’s the best of both worlds. Hannah Montana would be so proud.
