Excel Tip: How To Insert Line Breaks In Cells

Excel for beginners: learn how to create line breaks in cells with the ALT ENTER shortcut. Follow ‪@ExcelCampus‬ for more Excel tutorials, including formulas, Pivot Tables, VBA, and other beginners to advanced Microsoft Excel training.

[@oYinYano]

…this could have saved me so many headaches in my old job

[@MsTheresa7412]

This was a much needed short!!!

[@ExcelCampus]

Thanks! 🙂

[@mohdnajibabdulmajid7358]

Nice knowledge sharing

[@ImBamanPiderman]

You just fixed me

[@the0109]

Thanks

[@StepByStepExcelTutorials]

Such a time saver! So useful!

[@ExcelCampus]

Glad you think so! 😀

[@May-le6hp]

Thank you

[@fasebingterfe6354]

This is gonna save so much time from excel work

[@cruzinsweetsntreats]

Very cool

[@jahmeheru]

Game changer!!!

[@mairead354]

Wow, thanks so much!

[@ExcelCampus]

You're welcome, Mairead! :)

[@DH-ts6ho]

As an excel sheet, I can co firm that this is the right way to use me.

[@antygona-iq8ew]

thank you !!!!

[@ph7846]

Great tip. thank you!

[@ExcelCampus]

Glad it was helpful, @ph7846 ! 😀

[@jocelynllamas6600]

I. Love. You. I r3ally didnt lnow this trick!

[@Not_Sure-2020]

Good to know...in other text fields (non-excel) you usually use shift-enter and when that didn't work in XL, I never looked to do it again.

[@sharkywightman3397]

Awesome 👌

[@ExcelCampus]

Thanks, Sharky! 🤗

[@nandakishore5325]

😘😘👍👍

[@a.j.wilkes6352]

And in formulas! Not that huge nested formulas are a good thing, but this helps to make sense of things when doing accounting detective work.

[@gct436]

I must admit, I didn’t know that before

[@cathimclean3230]

How did I not know this?????

[@snehlatasingh7303]

Wow

[@qp4367]

teach me your ways

[@antoneilk5827]

Use this comment as your 1000 likes button! 👌 👏

[@elymX]

how do you undo the line breaks?

[@IngenieroProgramador]

hoW do I add line break if I concatenate two or more text from different cells? like adding the line break in the concatenate formula

[@user-qe4qt1bj3r]

what if we have more than 10000 cells to Alt+enter? Is there a faster way to do so?

[@cindyhammack68]

Alt 7 adds bullets

[@Rice0987]

2nd case:
ctrl+h
, {TAB} ctrl+j ?🤔

[@mousumikumari-nv7lr]

I use ms office 2007 but the shortcut key is not working , what can I do

[@stuart5597]

How did you get the profit and loss numbers to show green and red?

[@SylviusTheMad]

Conditional formatting.

[@kiyoshimatsutsuyu1931]

CHAR(10) will force a break in formulas, too 🪄