Format Cells is used to make reports easy to read and analyze.
You can use the “Format Cells” option to split a cell diagonally in Microsoft Excel 2010 and 2013.
Let’s take an example to understand the how to write text in diagonally split cells in Microsoft Excel.
Split a cell diagonally through shortcut keys
I have data in the range A1:F10, in which column A containsnumbers, column B dates, column C customer bank, column D Market, column E Quantity and column F containsthe income details.
To diagonally split the cells follow the below mentioned steps:-
Split a cell diagonally through the Menu
This is the way to split the cell diagonally. You can use this option if you want to define two main headers in a cell.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.