Split a Cell Diagonally




About this tutorial:

Video duration: 6:39
Check out my Blog:

I’ll show two ways to diagonally split a cell. One way is a put a diagonal line through a cell and the other is to insert a shape object.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

48 thoughts on “Split a Cell Diagonally

    Sleep Music 睡眠輕音樂

    (June 13, 2018 - 4:34 am)

    ONE BUTTON TALK SIX MINUTES

    chennai tax

    (June 13, 2018 - 4:34 am)

    Thank you

    mohamed bourai

    (June 13, 2018 - 4:34 am)

    Thank you

    اسير الذكريات

    (June 13, 2018 - 4:34 am)

    Thank you

    Asif rasheed Rasheed

    (June 13, 2018 - 4:34 am)

    Thanks Alot. Please keep it up

    Steph 編集

    (June 13, 2018 - 4:34 am)

    Was here for agario/ alis.io

    SwimminInMud

    (June 13, 2018 - 4:34 am)

    Thank you !!!

    Brittney Glass

    (June 13, 2018 - 4:34 am)

    How do you do this with the line going the other way?

    meoshie

    (June 13, 2018 - 4:34 am)

    OMG AMAZING!!!
    Thank you so much !!

    WhyTe io

    (June 13, 2018 - 4:34 am)

    oh i thought this was gota.io -_-

    KickAce

    (June 13, 2018 - 4:34 am)

    Спасибо большое за помощь)))

    Hope Bouldin

    (June 13, 2018 - 4:34 am)

    Thank you so much, this was so helpful!

    Terri Roberts

    (June 13, 2018 - 4:34 am)

    Thank you!

    Rick Math

    (June 13, 2018 - 4:34 am)

    I can't copy and paste to Word because it misaligns 😡

    Johnny

    (June 13, 2018 - 4:34 am)

    HOW DO YOU SPLIT A SINGLE CELL horizontally ? (i don't want TWO COLUMNS) – I just want a black bar to appear in the middle of the cell.

    (that I can influence later on to increase the size of the cell on the left and decrease the size of the cell on the right ,or something like that)

    icequeenwaikato

    (June 13, 2018 - 4:34 am)

    THAT WAS SO HELPFUL, YOUR A GREAT TUTOR, THANKS

    K.Sreekumara Warrier

    (June 13, 2018 - 4:34 am)

    Thanks a lot for the information,which was not seen available in the Excel help.Kindly advise as to how to align the text to come at left top for the upper portion and bottom right for the lower portion.

    PEIWEN LIU

    (June 13, 2018 - 4:34 am)

    how about the macbook, in which I don't have the ALT key to start a new line

    Adrian Tarlea-Rusu

    (June 13, 2018 - 4:34 am)

    Thank you very much for this! I've searched a long time such a tutorial

    iHealthSpa Canada

    (June 13, 2018 - 4:34 am)

    Works for me ,thanks for sharing!

    Doc Holliday

    (June 13, 2018 - 4:34 am)

    Thank you for the excellent info –well played, man!

    Thank you very much, would you mind type in words what are you saying between 1:451:58, i got lost there when you said press the "*" and enter
    Thank you

    Tejas Patel

    (June 13, 2018 - 4:34 am)

    Very Productive video.

    Pat Trainor

    (June 13, 2018 - 4:34 am)

    "We don't want a right triangle, we wand a left triangle!" Funny! 🙂

    Erin Snider

    (June 13, 2018 - 4:34 am)

    Wonderful! So helpful, thank you!

    Nicolas Gomez

    (June 13, 2018 - 4:34 am)

    The Diagonal its messed up…it should go From TOP LEFT to bottom right, thats how its supposed to be…pure logic of where is the Column and where are the Rows. How you draw it has no sense. But Thanks because it helped many people (not me because i thought it was an easier and built in way)

    YuChen Cheng

    (June 13, 2018 - 4:34 am)

    Hi, is it possible to do conditional formatting for the split cell when there's two pieces of information?

    evrenyilmaz55ey

    (June 13, 2018 - 4:34 am)

    GREAT JOB THANKS

    Digger060

    (June 13, 2018 - 4:34 am)

    Perfect.  My favorite was the triangle version.

    leebret1

    (June 13, 2018 - 4:34 am)

    that was fun, I did both for practice.

    Lakmal Edirisinghe

    (June 13, 2018 - 4:34 am)

    Thank u very much. it helpful for me.

    Khang Ngo

    (June 13, 2018 - 4:34 am)

    fantastic!!!!

    Sky Satshop

    (June 13, 2018 - 4:34 am)

    cheers

    Krishna Prasad

    (June 13, 2018 - 4:34 am)

    Great. Thank you very much.

    Paula Nichols

    (June 13, 2018 - 4:34 am)

    Great video! Thank you so much!

    Nelson Neocleus

    (June 13, 2018 - 4:34 am)

    Dear Doug
    Thank you for the trick.  It's one of the (many) things I couldn't do with Excel.  (My knowledge of "descriptive statistics" is mostly from the 1970's, before the rise of computer software.)

    vakos15

    (June 13, 2018 - 4:34 am)

    Thank you 🙂

    Jolisa Dillard

    (June 13, 2018 - 4:34 am)

    Thank you so much!

    Jannette Camejo

    (June 13, 2018 - 4:34 am)

    Wow..!!! thank u very much, I really liked it.

    Jose Antonio Ruiz Postigo

    (June 13, 2018 - 4:34 am)

    Very nice 🙂

    Sigurdur Runarsson

    (June 13, 2018 - 4:34 am)

    Loved it. Simple but yet I did not know this.

    sherpadoody

    (June 13, 2018 - 4:34 am)

    Thanks that was helpful. Is that your stomach i hear at 1:57??

    ElFoz99

    (June 13, 2018 - 4:34 am)

    The problem with the second method is when you want to fill the other side of the cell with a triangle. You have to rotate it 180 degrees to make it the right orientation, so the text is upside down.

    Amal Gupta

    (June 13, 2018 - 4:34 am)

    Thanks Doug!! Your video helped me to overcome a irritating nag 🙂

    Borislav Stoykov

    (June 13, 2018 - 4:34 am)

    Hi Doug H, good video but I know all this you showed. I want to know how to split a cell and insert in both of its parts separate formulas (in one cell). This is the homework that our academic university professor gave us and he tells us that it is called "The torment of programmer" 😉 . So, do you know how it has to be done?

    Wh Tan

    (June 13, 2018 - 4:34 am)

    I like very much the cool little trick included in your videos, eg in this one, press ALT to lock the object triangle to the cell's size.

    Rehab Alyasmin

    (June 13, 2018 - 4:34 am)

    Thanks for the video. It was a great help.

    Vdan

    (June 13, 2018 - 4:34 am)

    This sure is useful mate, keep it going.

Leave a Reply

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