How to Split a Single Cell diagonally in Excel

By | April 22, 2019

How can you Split a Single cell in Excel to give you data a perfect looks in your sheets This is required when you wanted to create table and wants to show data table with two different cells data into a cell which splits diagonally.

For E.g:-

How-to-Split-cell-diagonally-in-Excel-ExcelBlackBook.com

 

You have a data with table as shown below, where you have dates and employee names listed as below and you wanted to merge both the cells Date and Name into a single cells referencing the headers.

Let see how we can Split a Single Cell diagonally in Excel

1. Right click on the cell where we want to put “Date” and “Name” and select the option Format cells from the drop-down.

How-to-Split-cell-diagonally-in-Excel-1-ExcelBlackBook.com

2. Select a diagonal border you’d like to specify in the cell

How-to-Split-cell-diagonally-in-Excel-2-ExcelBlackBook.com

3. Click “OK”

Set the cell’s Horizontal Alignment to “left” and vertical alignment to “center”.

How-to-Split-cell-diagonally-in-Excel-3-ExcelBlackBook.com

4. Type in “Date” then Hit “Alt+Enter” which places the cursor in the second line of the cell. The type in “Name”.

How-to-Split-cell-diagonally-in-Excel-4-ExcelBlackBook.com

5. Then use the space bar to push the “Date” to right to accomplish the task of Splitting a Cell Diagonally in Excel.

How-to-Split-cell-diagonally-in-Excel-5-ExcelBlackBook.com

The Above tip is very important when you want to represent data in a tabular format.

Enjoy Excelling!