Google Search

Custom Search

How to split a cell diagonally

Let say we need to split the cells diagonally. Mainly when we want make a nice looking table.

Let say we need a table showing machine numbers and outputs per day.




As you can see event though the data can be represented properly, the presentation part is not very good as there will be empty cells (colored in yellow).

A nicer table should have "Date" and "Machine" in the same cell. Just like the one below,




Let see how to do this.

1. Right click on the cell where we want to put "Date" and "Machine" and click on Format cells.



Select "Border" and click on the diagonal border.



Click "OK"

Set the cell's Horizontal Alignment to "left" and vertical alignment to "center".




Type in "Date" then Hit "Alt+Enter". The type in "Machine".




Use the space bar to push the "Date" to right to get what we want.




If you want to have two colors for the split area you can try the "Fill effects". Choose "two colors" and "Diagonal Down". This is the best I can think of.





Please note if you want to use the value (date machine), this is not the method. 

As always love to have your comments. 






24 comments:

  1. What do I do if I want to color each half of the cell in a diff color?

    ReplyDelete
    Replies
    1. Hi, Thanks for the question. I have added some more text and images on how to do the split colors. If can think of better idea in the future, i will update. Again thanks for interest.

      Delete
    2. http://www.youtube.com/watch?v=0s5OiRMMzuY

      Delete
    3. Here is my solution to this problem which uses fill effects in VBA and has No blending of colors. (Actually very little) and you can eliminate even more by changing the .49 and .51 colors stops to be even closer together say .49999 and .50001.

      https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/how-to-split-the-color-background-of-a-split-cell/ec143e20-a47d-474d-afd5-6c93faaba38c

      Delete
    4. This was my main issue with all the other solutions. The one that I saw that truly gives you two distinct colors was too much effort to use regularly. So, I wrote an add-in for this. You can get source code, instructions and download at https://github.com/evanbarr/Excel-TableCornerLabels.

      Delete
  2. Thanks, great tip simply explained.

    ReplyDelete
  3. Good tip and neatly explained...plus one for you

    ReplyDelete
  4. Excellent tips! They helped me solve my problems with excel. Kudos to you ^_^

    ReplyDelete
  5. Thanks, good tip, well explained.

    ReplyDelete
  6. thank with the tips they real help....well structured

    ReplyDelete
  7. Thanks a lot, this saved my time :)

    ReplyDelete
  8. add two text boxes over the cell and they can be edited and arranged independantly, for different colors use shapes. Make shure they move and resize with cell

    ReplyDelete
  9. Excellent tip, explained very well. Thanks!

    ReplyDelete
  10. Thank you. Exactly what I needed.

    ReplyDelete
  11. If you want to know more about "Split a Cell Diagonally in Microsoft Excel", check this link ........

    http://www.exceltip.com/tips/split-a-cell-diagonally-in-microsoft-excel.html

    ReplyDelete
  12. if there is no option of format cells...??

    ReplyDelete
  13. Thanks for the Tip!

    ReplyDelete
  14. Thanks for the tips.
    But, I prefer to use a shortcut CTR+1 to bring up the format cell dialog box

    ReplyDelete
  15. I have a problem, when i want to print it. Cause then it pushes everything to the left again. the spaces are ignored.

    ReplyDelete
    Replies
    1. I did a quick check, i am able to print as it is. I am not sure what is the issue.

      Delete

 

blogger templates | Make Money Online

Google Analytics Alternative ExpiresDefault access plus 1 year