Add or Remove Line Breaks in a Cell in Excel

🔵 Quick way to add or remove line breaks in Excel. There's a special shortcut you need to use, in the Find and Replace dialog box!

💡 Related Links 💡

🔴 Related Excel Videos 🔴

⏰ Video Timeline ⏰
00:00 Create a Line Break
00:23 Remove Line Breaks
01:27 Line Break Shortcuts
01:34 Get the Workbook

🔥 Products I Use and Love
--As an Amazon Associate I earn from qualifying purchases

🔶 Instructor: Sarah, Contextures Inc.
#ContexturesExcelTips

[jimbaesler]

I searched for hours trying to find a video to solve this problem and yours is the only one that did it...much gratitude

[idoctorvic]

Short and sweet! Without foreplay and introductions like on other channels. Great work!

[osamedeosadolor]

Wow! This is the first time I am actually getting the exact solution to a problem. Thank you

[EnkhturDamdinjav]

alt+enter is not working on my excel office plus 2019

[jessicaamaya]

This just saved me at least a half hour or more! thank you!!

[wayneedmondson]

Hi Sarah and Debra. That's a great tip! Thanks for sharing :)) Thumbs up!!

[MilosVukovic-rgio]

Sara thank you. You have saved me a lot of time !

[adejames]

Thank you! This tip is appreciated. <3

[draganalazarevic]

Thank you so much 🙏 You saved me hours of work!

[patrickschardt]

I was just looking for this exact tip. I needed to remove extra line breaks in a bunch of formulas but didn’t know how to do it

[Shamshir_Shaikh]

what is the shortcut to change width and height of all columns together ?

[PM-stvu]

Hi, can you please help with macbook shortcut on the same?

[paiboolkitworawut]

How to remove line break and move to the lower cell?

[rpr]

How to replace two consecutive line breaks with just one?

[trisnaadisti]

Thank you this is very usefull for me 😁