How to Split a Single Cell in Half in Excel

Excel has a lot of features that are meant for performing enormous operations and formatting. You may need to add two different types of headings in a single cell and for performing this task, starting with splitting a single cell in half.

Split a Single Cell in Half in Excel

 

Method 1 – Split a Single Cell in Half in Excel Diagonally

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

You see that whatever change I make with the cell; the format doesn’t change.

Method 1.1 – Split Diagonally Down

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. We want to split this cell into two so that one part contains the text “Employee” and another part takes “Month“.

Steps:

  • Select the cell that you want to split in half.
  • Type your two words with space between them and press ENTER. In this case, we have typed Employee and Month in cell B4.

  • Go to the Home tab.
  • Click on the small arrow on the bottom-right corner of the Alignment group of commands.

  • Open the Format Cells dialog box and go to the Alignment tab. The keyboard shortcut to open this dialog box is: CTRL + 1
  • In this dialog box, select the Distributed (Indent) option from the Horizontal menu and the Center option from the Vertical menu.

Format Cells Dialog Box to Split a single Cell

  • Open the Border tab and select the diagonal down border (image below). You can also select a Border Line Style and Border Color from this window.
  • Click on the OK button.

Select Diagonal to split a single Cell in Half

  • Here is the output.

Split a Cell in Half in Excel

Read More: How to Split One Cell into Two in Excel


Method 1.2. – Split Diagonally Up

For the same set of data, if you want to split a cell in a diagonally up way, change the alignment just like you did for diagonally down but here, choose this border option from the Border tab.

Select Diagonally Down to Split a Cell

  • And here is your result.


Method 1.3 – Split a Cell Diagonally Using Objects

Steps:

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

The following GIF represents all the steps described above.

Using Object to split a Cell


Method 2 – Split a Single Excel Cell in Half Horizontally

Using the above method (Using Objects), you can also split a cell in half horizontally. This time, you’ll split using a rectangle to draw an object in the cell, as seen below:

Here is the final output.


Add Two Background Colors to a Split Cell in Half in Excel

Steps:

  • 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 to open the Fill Effects dialog box
  • Choose a color for Color 1 open and choose another color for Color 2 field.
  • Select the Diagonal down from Shading styles
  • Click on the OK button (two times)

Split Cell and Add two Colors

  • Here is the output.


Further Reading

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

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

  2. Very Use full tips thanx for you..

  3. Reply
    Arun Panangat Anandadasan Sep 13, 2021 at 5:57 PM

    Great Tip. Thanks

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo