Often you may want to split a cell diagonally in Excel to display two different values in each corner of a cell, such as in cell A1 in the following screenshot:
Fortunately this is easy to do by adding a diagonal border within the Format Cells feature in Excel.
The following example shows how to split a cell diagonally in practice.
Example: How to Split a Cell Diagonally in Excel
Suppose we would like to split cell A1 diagonally in the following sheet in Excel so that we can display “Quarter” in the top right corner and “Product” in the bottom left corner of the cell:
To do so, right click on cell A1 and then click Format Cells from the dropdown menu:
In the new window that appears, click the Border tab, then click the diagonal icon, then click OK:
Once you click OK, a diagonal border will be added inside cell A1:
Next, click cell A1.
Then type Quarter, then press Alt + Enter to move to the next line in the same cell, then type Product:
Lastly, click in front of the word Quarter and simply press the space bar several times to push the word Quarter towards the right side of the cell:
The end result will be that Quarter appears in the top right corner and Product will appear in the bottom left corner of the cell:
We have now successfully split cell A1 diagonally.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
How to Split a Cell Vertically in Excel
Excel: How to Split String Based on Multiple Delimiters
Excel: How to Split Word into Individual Letters
