Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell

VBA/Macros Course (80% Discount): www.teachexcel.com/vba-course...
Excel Forum: www.teachexcel.com/talk/micro...
More help: www.teachexcel.com
More, including Excel Consulting, Macros, and Tutorials.
Neat Excel tip for adding extra lines to cells in Excel. This allows you to have paragraph style formatting for text within a cell whereby you can enter text on lines below other text within the same cell in Excel. This allows you to have better looking and better formatting spreadsheets in Excel. You can also use this technique to insert blank lines after or before text within a cell in Excel.
This method of entering text into cells allows you to avoid using the text box to enter large amounts of text in Excel.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!

[@TeachExcel]

****** BLACK FRIDAY SALE ******
VBA/Macro Course (80% OFF) -> www.teachexcel.com/vba-course-update.php?src=yt_pin_ySf8ERtH2kU
Professional Forms in Excel (65% OFF) -> www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=yt_pin_ySf8ERtH2kU
Email from Excel (65% OFF) -> www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=yt_pin_ySf8ERtH2kU

[@nycollassilva3558]

Rfhgccgfcq1cb

[@jitinnagpal3622]

L

[@betsyikeme1972]

Thank you, 11 years later and this just saved me some serious embarrassment. Thank you.

[@micky469]

Thank you soo much.. We learn everyday

[@dStrojdStroj]

@TeachExcel how about having let's say 3 lines. Two in normal style and one hyperlink to a google maps location? Can you have hyperlink in a cell and add some text without hyperlink? Specifically google maps link. So a box would contain:
lunch at
(hyperlink)
then a movie
all in one box but only the hyperlink line colored and underlined...

[@thicksauceism]

I could relate lol

[@ichigo3794]

Literally!!!! Lol

[@mihaly1555]

Same lol

[@amaltijarah6561]

It'been 10 years. It'll always be benificial to those who in need with this tutorial. Thanks! 🙏

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@gossienworu3210]

How many decades I have been using excel, I have never known how to do something so simple. Thanks a million!

[@thescienceandengineeringco4079]

He made it even before I knew excel exists and today I got help from it after 11 year. Kudos RUclips.

[@Missony74]

Thank you so much - such a simple things that make a huge difference!

[@nadsalman7881]

10 years ago video, but you help me in less than 2 minutes. Thank you so much 😭😭😭😭😭😭😭❤❤❤❤❤❤❤❤❤❤❤❤❤

[@relaxtv584]

See ruclips.net/video/twxNznfO3nk/видео.html

[@Grandmaster-]

This helped a whole lot!
I'm the HR for a company and embarrassingly enough I forgot how to do this lol.
You have my thanks.

[@nicholegilbert1717]

This video really stood the test of time, going on 12 years later and it helped me with something i was bursting my head over trying to figure out for another co worker ..lol.. New Subbie to do refreshers. Thank you so much!!!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@JavedSidiqi]

Same here, I cant believe how useful this video was for me...

[@charmainespence4445]

Lifesaver so happy to find this subscribed !!

[@xPawful]

For MAC users; it's COMMAND + option/ALT + ENTER.

[@FranklynGrant]

Thank you ExcelisHell for the tip and xPawful for the platform I needed it in.

[@traxinternational622]

xPawful thank you

[@christab3972]

THANK YOU!!!!!

[@renukhera7028]

thanx xpawful

[@AvantiMorocha1]

Thank you :)

[@aortiz1986]

I spent a few minutes trying to figure this out! Thank you!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@simpleexcelexamples9619]

Great video! The lay-out has changed a little bit, but it is still applicable and easy to understand!

[@Therapist75002]

Thank you! You just made a school project much easier for me!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@esme5111]

THANK YOU! This really help me
So much! I’ve been struggling for 30 minutes on this!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@cruzgonzalez5276]

Before finding this video, I was copying and pasting a textbox in every cell...Thank you! Thank you! Thank you!

[@aienjamir89]

Sameeeee

[@alisalis5815]

Great video - short and sweet; the best video on this topic. Thxs so much!

[@TheMissionette]

Just what I needed to know! Thank you~

[@ovaistauheed]

i was desperately looking to get ths done ...thank god i visited youtube for multiple line text within a single cell....thanks you saved my time and it really hepled me a lot...

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@basemahassan3933]

Thank you so much you have no idea how I have been struggling for the past 30 min trying to do this on my own 😅. Thank you life saver

[@paulphilippou656]

Thank you, explanation was simple and user friendly. LIKE!

[@100PercentOS2]

Thanks. This really helped me though I was familiar with resizing the cells already.

[@abdulaziz-montana]

You helped me very well. I really want to be appreciated for ya .

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@aryakumar4700]

Thank you so much for this formula.
It's helpful.

[@syedrahman4096]

13 years later and on the latest excel, still works like a charm. Thanks Buddy😊

[@mina7016]

Enfinnn!😍 Merci!!!

[@habiebiee1]

and I was going insane at work today...THANK YOU VERY MUCH!!

[@sergeantrecker3639]

Thank you so much. You just made a straight forward video

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@staceem]

Exactly what I needed - thank you! This trick works in Google Sheets too, which is what I'm using :)

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@ptnewman2674]

PERFECT!!!! I've been tying to figure this out FOREVER. :-) LOL Thank you!!!

[@SM10170]

Teri

[@hardworkdedicationjohno8105]

Thank you this was to the point and really helpful!!

[@smijilchirayil2431]

Great

[@caives]

Thanks bruh! You're the best!

[@maythamsaeed533]

Very useful and very direct (going to the point) Many thanks

[@classxstudent4310]

Thanks. This helps me out ... i have subscribed your lovely channel

[@zahidshad6194]

thanks buddy you saved me. God bless you.
even after 14 years this video has the value is equal to gem 😂

[@prarthanaac]

Cleared my one specific doubt so easily. Thanks much 🌷

[@swone6349]

Subscribing because of your voice and clarity! Was looking for auto fit functions.

[@ioanabiris3472]

Thank you very much!! It was very useful!!

[@gulafshaparveen6797]

DUDE!!! YOU HELPED ME! THANK YOU!

[@dharmeshmistry8648]

this is really helpful, i was searching for this exactly, THANK YOU

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@shuchita__saxena]

Thank you so much!
It really helped!

[@BarryWraps]

thanks, this just saved my grade in my history class

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@theladypassionate8195]

This was very helpful and straightforward. Thank you.

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@pattietempleton7580]

Thanks for the simple, clear explanation. I don't use Excel often and had forgotten how to do that.

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@camsongs1916]

Thanks , you so brilliant ...

[@narendranaidu7]

Super explanations Bro... Thanq..

[@emmanuelcann1750]

Thank you very much. This was really helpful

[@javiertorres3949]

You the man!!!! It worked thank you!!!

[@jessierobinson1489]

PERFECT! Thank you.

[@mahaboobpeera6552]

Thanks for the useful information, perfect explanation

[@NC-it2ws]

thank you so much for the long searched answer!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@as23163]

Thank you so much for this!!

[@mstabspeople]

Thanks for the vid, i never had to do this before today and i needed it done very quickly. This vid saved me time i didn't have!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@hollychaffee606]

Thank you! I was frustrated trying to figure this out. I have a Mac, so I used option + enter, and it worked!

[@landofimPatience]

For Macbook it is "control option ENT" you hold control and option at the same time then press enter. I have Office Mac 2011 and that's how i do it.

[@Lee-AnneJ]

Thanks so much for that, just what I needed to know, saved me searching for it :)

[@kaylawilliamsmehr2788]

This takes me to the next cell when I want to be on the next line within the cell

[@relaxtv584]

See ruclips.net/video/twxNznfO3nk/видео.html

[@Jaiii_Tee]

Thank you

[@muskanceleste]

thank you so much man, i opened your video at first and it showed exactly what I was looking for. Love from India.

[@purplepurple7519]

It's so helpful for me. Thank you so much

[@thisisfervin]

Amazing!! it works. Thanks to you.

[@fordjanakpurshowroomgoford6267]

UR VIDEO IS SO CLEAR TO UNDERSTAND NOT LIKE OTHERS THANKS

[@hemalatha-ms5zc]

This helped a whole lot! Thank you

[@mohammadasifahmadzai6784]

Thanks that what I wanted to learn

[@zaheerazariwala5381]

Thank you so much. It really helped me🎉

[@rahulsinghrajput3548]

Really helpful❤

[@gamerlovesgaming550]

Thank you!!! Saved me some time!!!

[@FutureDevZ]

Thanks man you helped me out

[@kingsleyukaulor3704]

This video means everything to me. From the start to the finish, it was 100% excellence. I like your voice too. Thank you. I got me to subscribe.

[@relaxtv584]

See ruclips.net/video/twxNznfO3nk/видео.html

[@lomajakun6566]

Thank you for your very kind teaching this is really helpful for me

[@dinsheshey1]

Made my day
Thank you

[@mohammedaminemedboub7568]

It works, thanks a lot mate :)

[@aienjamir89]

You're a saviour 🙌. Thanks greatly

[@fatinussarahjamil3682]

thankyou so much for this tippp... you just save my life!!!!!

[@zarrarahmed1951]

Valuable tips. Thanks

[@dominiktodt642]

Thank you. It really helped me.

[@John3K21]

Super helpful. Never knew how to do these until I searched this just now. Thanks!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@SoorajVarrier777]

Man! You saved my day. Thank You Very Much! :) Stay Happy!

[@relaxtv584]

See ruclips.net/video/twxNznfO3nk/видео.html

[@kirkramble131]

So easy! You rock so very much, thank you!

[@relaxtv584]

ruclips.net/video/twxNznfO3nk/видео.html

[@samnanou9659]

I’m really thankful for this helpful video

[@MrObeytok]

Amazing, thank you!

[@deenanaidoo6978]

Thank you, lots of help

[@ericbizimana828]

Thanks, man, you have saved me a lot

[@oasimakhatun4222]

Thank you it's really helpful

[@reshmawinnymathew4955]

Thanks a lot. This really saved me🌻

[@suevickyworld5278]

Thanks a million 💪🏻

[@vilasshembade3058]

Your video helped me more.

[@eglahernandez1626]

This was UH-mazing!!!! Thank you

[@gerrydaniel6172]

Thank You. Great Help

[@harshadbandkar4148]

thank you so much this vid is literally helping me after 11 years wow! 😊

[@fathiaabdullahi8780]

Thank, the video was very helpful.

[@som956]

14 years later, still very USEFUL, thank you !

[@ebbi9398]

Thank u. Its help me a lot.

[@Y19]

Thank you
Saved me in really needed moment

[@ajaybaxi6794]

Thank you very much for sharing this information

[@marvelade3606]

Why can’t more videos be simple and direct like this.

[@Krishna-ui6wp]

thank you so much .. u solve my problem. i tried two videos before but u taught in easy way.. thank u sir

[@sitinurafiqah7410]

thankyou. this really help me alottt.

[@harshildave4936]

Thanks I appreciate your work. After all it worked.
Thx man !!!

[@relaxtv584]

See ruclips.net/video/twxNznfO3nk/видео.html

[@JanellAlysse]

this seriously just saved my life.
thanks youtube.
thank you.

[@abdulrahemani8504]

Thank you man you helped me thanks alot!!!❤️❤️

[@laikapacheco_]

Whaaaat. it's that simple!! Thank you sooo much 😭❤️

[@GhayoorAli9128]

Thank you man👍🏼