No video :(

Split a Cell Diagonally

Подписаться 79 тыс.

Просмотров 332 тыс.

50% 1

In this video I'll show two ways to diagonally split a cell. This is a formatting trick to help put one word in the top corner and another word or set of words in the lower corner. You can even fill in one part of the diagonal with a different color. Most often this design trick is used to have two headers in one cell. I'll show more that one method to split the cell in half. One way is a put a diagonal split line (or slash) through a cell and the other is to insert a shape object.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Опубликовано:

3 мар 2012

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 93

@khanhnhutranle4457 2 месяца назад

Finally!!! You're such a lifesaver

@Zerkoto 5 лет назад

Thank you! I've been trying to find out how it's possible for 30 minutes and you are the only source of information regarding this simple but vital option...

@DougHExcel 5 лет назад

Hi ツZerkoto, glad you liked it, thanks for commenting!

@adriantarlea-rusu6800 8 лет назад

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

@nelsonneocleus4687 10 лет назад

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.)

@snides333 9 лет назад

Wonderful! So helpful, thank you!

@srunarsson 10 лет назад

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

@tejaspatel3144 8 лет назад

Very Productive video.

@ihealthspacanada3263 8 лет назад

Works for me ,thanks for sharing!

@mariapaulatovar 10 лет назад

Great video! Thank you so much!

@rahoob65 11 лет назад

Thanks for the video. It was a great help.

@camejane9889 10 лет назад

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

@Froggy_days. 9 лет назад

GREAT JOB THANKS

@whtan1815 11 лет назад

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.

@jolisadillard7568 10 лет назад

Thank you so much!

@KrishnaPrasad-hh2om 10 лет назад

Great. Thank you very much.

@GiaKhangNH 10 лет назад

fantastic!!!!

@elverdante 11 лет назад

This sure is useful mate, keep it going.

@lakedi74 10 лет назад

Thank u very much. it helpful for me.

@PatTrainor 9 лет назад

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

@leebret1 9 лет назад

that was fun, I did both for practice.

@rabatborn1 12 лет назад

Thank you a lot

@vakos15 10 лет назад

Thank you :)

@hopebouldin8584 7 лет назад

Thank you so much, this was so helpful!

@DougHExcel 7 лет назад

You're welcome!

@k.sreekumarawarrier5790 8 лет назад

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.

@DougHExcel 3 года назад

Hi K.Sreekumara Warrier, thanks for the comment! Alignment can be found in the ribbon for the to left. Bottom right will be the text box object.

@ernestol6325 4 года назад

Nice work - easy to follow - thank you!

@DougHExcel 4 года назад

Glad it was helpful!

@AmalGupta 11 лет назад

Thanks Doug!! Your video helped me to overcome a irritating nag :-)

@ummmomen 12 лет назад

Thank you.

@meoshie 7 лет назад

OMG AMAZING!!! Thank you so much !!

@DougHExcel 7 лет назад

You're Welcome!

@ruizpostigo 10 лет назад

Very nice :)

@terriroberts87 7 лет назад

Thank you!

@DougHExcel 7 лет назад

You're welcome!

@docholliday7548 8 лет назад

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

@markuscason7697 3 года назад

i dont mean to be offtopic but does anybody know a trick to get back into an Instagram account? I was dumb lost my account password. I would appreciate any help you can offer me

@ahmirsamson3913 3 года назад

@Markus Cason instablaster ;)

@markuscason7697 3 года назад

@Ahmir Samson i really appreciate your reply. I got to the site on google and im waiting for the hacking stuff atm. I see it takes a while so I will get back to you later with my results.

@YeOldeKamikaze 5 лет назад

>2:40 ALL I NEEDED THNX BAI

@DougHExcel 5 лет назад

Hi YeOldeKamikaze, thanks for the comment!

@yuchencheng5470 9 лет назад

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

@MohAboAbdo 6 лет назад

Thank you

@DougHExcel 6 лет назад

You're Welcome!

@asifrasheedrasheed3711 7 лет назад

Thanks Alot. Please keep it up

@DougHExcel 7 лет назад

Hi Asif rasheed Rasheed...you're welcome, glad you liked!

@asifrasheedrasheed3711 7 лет назад

Sir I am a software developer. I have made the biggest software on excel. I want to show. Can you send me your email: My Email: hameedmogul2007@gmail.com My Contact Number: 0300-7051397 I am from Pakistan. >>>>>>>>>>>>>

@dibyohere 5 лет назад

6 min is valuable. You could say at the first that there is no option to split the cell diagonally.

@DougHExcel 3 года назад

Dibyajyoti Sarkar, that is very interesting...thanks for letting me know.

@akshay_dapke 5 лет назад

Thank you sir

@DougHExcel 5 лет назад

You're Welcome!

@TheWarnator 8 лет назад

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

@TheWarnator 8 лет назад

@skysatshop1975 10 лет назад

cheers

@Ace7558 7 лет назад

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

@DougHExcel 7 лет назад

Пожалуйста!

@borislavstoykov3103 11 лет назад

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?

@SwimminInMud 7 лет назад

Thank you !!!

@DougHExcel 7 лет назад

You're Welcome!

@mannyr5462 Год назад

is it possible fr you to show us how to split a cell horizontally

@el_foz 11 лет назад

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.

@Xcellentone 4 года назад

Can you use formula on both halves of a split cell?

@DougHExcel 4 года назад

Nope

@BrittneyGlass 7 лет назад

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

@DougHExcel 7 лет назад

with the shape you can have it flipped the other way. select it, go to Format and select the Rotate command to flip it horizonally.

@Lakesider 8 лет назад

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

@Lakesider 8 лет назад

+PEIWEN LIU ya, I found the solution. control+option+enter thx anyway

@buzzingify 7 лет назад

Thanks!

@DougHExcel 3 года назад

Hi P L, thanks for the comment!

@sherpadoody 11 лет назад

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

@JohnDoeL337 8 лет назад

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)

@DougHExcel 8 лет назад

i don't think this can be done in Excel. You'd have to use two cells make the borders more prominent and merge your adjacent cells to hack this. Or use the drawing tools to draw a line.

@JohnDoeL337 8 лет назад

Good advice, but I have just one cell; the adjacent ones from the left and right are taken. I want to input text on the left and a subchapter on the right. Guess i'll use the drawing tools.

@gibbs3145 7 лет назад

This can be done. Check out Gibbs3141 comment at the site below. Basically you will use fill effects and then modify the fill effects code in VBA to remove the blending of colors. 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

@sleepmusic6087 6 лет назад

ONE BUTTON TALK SIX MINUTES

@DougHExcel 3 года назад

Sleep Music 睡眠輕音樂, that is very interesting...thanks for letting me know.

@rms7999 7 лет назад

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

@alaaragap8942 7 лет назад

right

@DougHExcel 3 года назад

Rick Math, that is very interesting...thanks for letting me know.

@NicolasMartinianoGom 9 лет назад

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)

@JohnDoeL337 8 лет назад

Yeah, that's what I was thinking the 1st time I saw this. He should have pressed the bottom right button instead of the left one.... But people aren't inspired some of the time...