Kathy asks how to type numbers in a diagonally split cell. Episode 790 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Nguồn: https://12m-15m.org/

Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe

YOU SAVED MY ASS THANKS

how would I split a cell horizontally in excel 2010?

Hi Mr. Excel. Is there a way to split an individual cell into two or three rows within the cell? I need the values to add up once I'm finished with my spreadsheet. Sometimes we pay two or three vendors against one invoice but our invoices are loaded in rows and I need to show each payment on one row. Right now my only options is to create a blank row below the invoice but that doesn't seem quite right. Any suggestions? Thank you! love your videos!

Can I colour the 2 parts of the cells in different colors ?

If possible I would prefer to use 4 cells instead of the one cell.

A1 for Value on the top Left (left bound),

B1 and A2 formated with the diagonal line

B2 for the value below the line…

and backcolor set to white if needed (this hides the grid for those cells).

hello, Can you split a cell in half in 2013 like you could in 2007?

can i fill in different colors for the split cell??

I've tried for hours, thank for saving my life!!!

Alt whit what?

thanks man

thank you

cheers for that, big help