How to split a single cell in half in Excel (diagonally & horizontally)

Do you want to know how to split a cell in half in Excel (both diagonally and horizontally)?

Want to know how to split a single cell diagonally with two background colors?

After splitting a single cell in half, you want to place text in one part and insert a link in other?

how to split a cell in half in excel

You’re in the right place.

This is the best-researched guide on the above topics.

Let’s start…

How to split a single cell in half in Excel diagonally (the best method)

This is the best method to split a cell in half (diagonally). Why? See the GIF image (below).

The way I am showing is the best way to split a cell in excel. As if you change the height and width of the cell, the decoration will be unchanged.

You see that whatever change I make with the cell; the format is not changing. That is what you want, right?

Let me show you how you can split a cell in that way. It is very easy.

# Splitting a single cell in half (Diagonally Down)

Follow these steps:

  • Select the cell that you want to split in half. And type your two words with space a between them. In my case, I type Employee and Month in the cell B2 and then press Enter

Input two texts or words in a cell with a space between them

  • Now click on the little small arrow on the bottom-right corner of the Alignment group of commands in the Home

click on the little arrow on the bottom right corner of the Alignment group of commands. It will open the Format Cells dialog box with the Alignment tab activated.

  • The Format Cells dialog box appears with the Alignment tab open. Keyboard shortcut to open this dialog box is: CTRL + 1

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

Format cells dialog box. Change the horizontal and vertical options with the Distributed (indent) and Center options respectively.

  • Now open the Border tab and select the diagonal down border (image below). You can choose also Border Line Style and Border Color from this window.

And finally, click on the OK button.

Select the diagonally down border option in the Border window of the Format Cells dialog box.

  • And you are done. Here is the output.

The cell is split in half (diagonally down).

# Splitting a cell in half (Diagonally Up)

To split a cell in diagonally up way, choose this border option from the Border tab.

Choose the diagonally up border from the Border window in the format cells dialog box to split a cell diagonally up.

And here is the result.

The cell is split in half in the diagonally up manner.

Split a single cell diagonally with two background colors

Let me show you how you can split a cell diagonally with two background colors.

  • Select the cell (already split in half)
  • Open the Format Cells dialog box
  • Open the Fill tab in the Format Cells dialog box
  • Click on the Fill Effects… command
  • Fill Effects dialog box will appear
  • In the Fill Effects dialog box, choose a color for Color 1 open and choose another color for Color 2 option
  • Select the Diagonal down Shading styles
  • And finally, click on the OK button (two times)

Split a single cell diagonally with two background colors. Click on the Fill Effects command in the Fill window in the Format Cells dialog box. Choose two colors, and choose the Shading Styles from the Fill Effects dialog box.

  • You’re done. Here is the output.

A cell is split with two background colors

How to split a cell diagonally in Excel using objects (effective in some cases)

This is another method of splitting a cell in half in Excel. We shall use Right Triangle Object to split a cell half in this way.

Let’s start.

  • Select a cell that you want to split and input one word (Employee) and make it Top Align.
  • Open the Insert tab -> Illustrations group of commands -> Click on the Shapes drop-down -> And select the Right Triangle from the Basic Shapes
  • Press and hold Alt key and place the Right Triangle into the cell.
  • Then Flip the triangle horizontally and input the second word (Month).

All the above steps are narrated in the following GIF image.

using objects to split a cell in half in Excel.

Split a single cell horizontally

Using the above method, we can also split a cell in half horizontally.

See the image below. I have used the Rectangle to draw the object into the cell. And then I have input a link to the object.

Split a cell in half in excel in the horizontal way.

Here is the final output.

Split a cell in Excel using object and adding hyperlink to the object

Related Readings

Conclusion

So, these are my ways to split a cell in half in Excel. I showed both ways: diagonally and horizontally. Do you know a better way? Let me know in the comment box.

Hope you like this blog post.

Thanks for being with us!


Hello! Welcome to my Excel blog! I am conducting deep dives into the world of Excel. Please join with me and explore Excel deeply. Keep in mind this African proverb: "If you want to go fast, go alone, If you want to go far, go together." Let's together explore Excel deeply! ☕

2 Comments
  1. Reply
    Anand November 21, 2018 at 2:36 AM

    An Excellent tip!
    Thanks for sharing.
    Regards.
    CMA Anand Karpe

    • Reply
      Kawser November 21, 2018 at 12:05 PM

      You’re welcome.
      Best regards

    Leave a reply