You can choose also Border Line Style and Border Color from this window.

Now open the Border tab and select the diagonal down border (image below).

In this dialog box, select the Distributed (Indent) option from the Horizontal menu and the Center option from the Vertical menu.

The keyboard shortcut to open this dialog box is: CTRL + 1

After that, open the Format Cells dialog box and go to the Alignment tab.

Now, go to the Home tab > click on the small arrow on the bottom-right corner of the Alignment group of commands.

In my case, I have typed Employee and Month in cell B4. And type your two words with space between them and press ENTER.

Select the cell that you want to split in half.

In order to serve this purpose, proceed with the following steps. We want to split this cell into two so that one part contains the text “ Employee” and another part takes “ Month“. It looks so unprofessional if you put two types of texts in a single cell without splitting the cell. Let’s say, we have a dataset of some employees of an organization and their monthly sales (in USD) till half of the running year.Īt the intersection of the row describing month and the column describing employee name, I have put two texts (i.e. Let me show you how you can split a cell in that way. You see that whatever change I make with the cell the format is not changing. This is the best method to split a cell in half (diagonally).

In this section, I’ll show you the way to split a cell in half diagonally. Splitting a Single Cell in Half in Excel Diagonally

Excel split cell in two columns