Split a Cell Diagonally in Microsoft Excel 2010

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.

img1

 

To diagonally split the cells follow the below mentioned steps:-

    • Select the cell A1 and in the Formula Bar, place the cursor after the word Headings.
    • Press “ALT+Enter” twice (once to wrap the text and second for an additional empty row space).
    • Press “CTRL+Enter” to accept the changes without moving from the cell.

img2

 

    • Press Ctrl+1 on the keyboard to open the “Format Cells” dialog box.
    • Select the Border tab and select the left diagonal border.
    • Select the Alignment tab.
    • From both the Horizontal and Vertical dropdown lists select Justify.
    • Click Ok.

img3

 

  • In the Formula Bar, place the cursor before the word Headings and press the space bar to add spaces and move the word to the right.
  • The data is aligned / split diagonally as per the picture below.

img4

 

Split a cell diagonally through the Menu

    • Select the cell A1 and in the Formula Bar, place the cursor after the word Headings.
    • Press Alt+Enter twice (once to wrap the text and second for an additional empty row space)
    • Press Ctrl+Enter to accept the changes without moving from the cell.
    • Select Home>More Borders (from the Borders icon in the Font Group).

img5

 

  • Select the Border tab and select the diagonal border.
  • Select the Alignment tab.
  • From both the Horizontal and Vertical dropdown lists select Justify.
  • Click Ok.
  • In the Formula Bar, place the cursor before the word Headings and press the space bar to add spaces and move the word to the right.

img6

 

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube