Split a Cell Diagonally in Microsoft Excel 2016

Split 6
The fact is, you can’t split a cell diagonally into two in excel but you can make it look like it is split as shown in above image.

Let’s say you have conducted a survey in different areas to know the population of several age groups. In cell A1 you have written “Age Range Area”. You want Excel to split cell into two, to show “Age Range” for Column Headings and “Area” for Row Headings.

First let’s split the Cell A1 into two. Now to split a cell in half in excel 2016 we will use an excel trick. Follow the steps below:

  1. Right click on A1 and choose format cells or you can use CTRL+1  excel shortcut to format cell.
  2. Split 5

  3. Go to the border tab and select the diagonal border line. There are two options for that. It does not split the cell but draws a diagonal line in the cell.
  4. Split 4

  5. Hit the OK button. And it’s done. But it’s not what we want to do.
  6. lit 3

  7. Now, we need to play with text here. To separate words in excel within a cell, we use Alt+Enter Command. This excel command enters a new line within a cell.
  8. Select A1.

    Go to the formula bar and place your cursor between “Age Range” and “Area”.

    Hit Alt+Enter, Repeat this until you are satisfied with the result.

    Split 2

  9. To align the text to the right of the cell, add spaces before it. In our case, we add spaces before “Age Range”. And it’s done.
  10. Split 1

Now it looks good. This is a makeshift in excel to split a cell in half diagonally. You can’t actually work on both parts but visually it looks split.

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