How to Split a Cell Diagonally in Excel (Two Headers in One Cell)

Step-by-step

The example is a quarterly revenue table: Q1 to Q4 down the side, and Chicago, Berlin, Tokyo and Sydney across the top. The top-left corner cell needs to say that the rows are quarters and the columns are cities. Excel can’t split a cell in two, so instead you make it look split.

Method 1: a diagonal border (the most reliable)

1. Click the corner cell, the one above Q1 and to the left of Chicago. Type Cities, press Alt+Enter to start a new line inside the same cell, then type Quarters.
2. Go to Home > Borders > More Borders. Pick a slightly thicker line style, click the diagonal border that runs from top left to bottom right, and click OK.
3. Align the cell to the left, then click into it and add spaces before Cities to push it towards the top-right corner. Press Enter when it looks right.

This is a manual tweak, but it stays exactly in place for anyone who opens the file, which makes it the best choice for files you share.

Method 2: a drawn line

Remove the diagonal border and the extra spaces. Go to Insert > Shapes, choose a straight line and draw it across the cell. Change its colour to match the table borders and make it a little thinner. Adjust the column width and row height as needed, and hold Shift while resizing to keep the line straight. Then use spaces to place one word above the line and one below.

The catch: a shape floats on top of the sheet, so it can shift slightly on other screens or computers. It’s fine for quick work but not ideal for sharing.

Method 3: spacing only

Delete the line and keep just the wrapped text, with spaces positioning the two words. It’s clean and simple, but it only works if your layout won’t change much later.

Remember

None of these methods actually splits the cell. Excel doesn’t allow that. They’re all visual tricks, which is why the diagonal border, which stays put no matter who opens the file, is usually the best option.