How to write multiple lines in one cell in Excel 😎

[@baishnabidas1743]

The fact that you considered that people searching for this might not have much time and hence you directly just said it, saved so much time nad helped me immediately, when I needed it! Thank you so much for this video.

[@cogwheelLearning]

That's wonderful! ❤️

[@cogwheelLearning]

I am creating KZbin videos to answer all your Excel questions. If you want to follow along, please subscribe and hit the thumbs up button. 🤗 If you want to support the channel beyond that please make sure to sign up on: ☕ www.buymeacoffee.com/cogwheel

[@akshaysawant8035]

The hint given in the start ALT + Enter....saved my life...God Bless you....

[@cogwheelLearning]

Thanks Akshay 🙏

[@maxmeddaauud8986]

I don't know how I thank you. You saved my time. I subscribed your channel as a sign of appreciation.

[@cogwheelLearning]

Thank you! Much appreciated 🙏

[@jujustateofmind5844]

How you went straight to the point is absolute! thank you

[@cogwheelLearning]

I appreciate you being here🙏

[@briangonsalez2173]

Excellent video! Quick and easy 👍🏼 exactly what I was looking for!

[@cogwheelLearning]

Nice!

[@shanks9926]

Thank you! Finally, I found someone who makes videos on this topic in English. Most of the videos available on this topic are done by Indian individuals who can't speak basic or even broken English.

[@cogwheelLearning]

I'm glad you're enjoying my videos. I hope I can provide helpful content for anyone that's looking for it.

[@lindascoon4652]

Thank you for getting straight to the point

[@cogwheelLearning]

I value your time guys, Thanks for spending a few minutes here ❤️

[@simonjosefsson1419]

Wonderful video, directly to the point and then including a little explanation afterwards. Bravo, you definitely earned a like!!!

[@cogwheelLearning]

Thank you so much sir🙏

[@dannykwak3433]

Oh wow that's what I looked for 1 hour myself!!!! Thank you

[@cogwheelLearning]

Hey, thanks for commenting. Be sure to checkout more videos on the channel. It might save some more time in the future ☺️

[@mariaboghean3047]

Great video! I like that you present the info in a short time, keep going!

[@cogwheelLearning]

Thank you! Will do

[@pamelaboggs222]

Thank you so much for telling me what I needed to know in the first minute. Exactly what I needed.

[@cogwheelLearning]

Wouldn't wanna waste your precious time 🙏

[@Nemisreyd]

perfect ! You've got my appreciation

[@cogwheelLearning]

Thank you! A thumbs up will help

[@Patty_Eli]

Thank you! Short and sweet!

[@cogwheelLearning]

You're very welcome 🤗

[@Super_Saiyan_Rainbow]

Thank you!

[@cogwheelLearning]

Thank you Mr. Saiyan!

[@blessedhoney8512]

So short and useful, thank you.

[@cogwheelLearning]

Thanks! Please checkout my other videos.. They are created similar to this one. Short and to the point.

[@nikkibiswal5375]

Thanks. Precise and helpful

[@cogwheelLearning]

As all things should be. Thanks for watching! ❤️

[@naphychileshe6123]

Nice video but when u get to the next column do u do the same?

[@cogwheelLearning]

yes, you do the same each time.

[@E52Matt]

Thanks so much so easy to follow and so helpful

[@cogwheelLearning]

I really appreciate your comment, Elise! ❤️

[@evelyngocela6673]

Thanks you Bro. short and precise

[@cogwheelLearning]

That's how we like it 🎉

[@MiuArtStudioUK]

Thank you :) the quick version made me smile

[@cogwheelLearning]

Awesome 😍

[@dominikmozes6569]

Great Video! Thanks for the quick info!

[@cogwheelLearning]

My pleasure. 😇

[@manutotheworld8889]

Thank you for saving my time. You deserve a like and subscription

[@cogwheelLearning]

Nice!

[@ChallengerRhino]

I had to smash the like button for this one. Never knew this option even exists.

[@cogwheelLearning]

Yeah, the Like button was really asking for it

[@thelivereactions]

Thanks u r very quick in solving problems 🎉

[@cogwheelLearning]

Thanks! How did the video helped you?

[@thelivereactions]

@@cogwheelLearning alt + enter 😃

[@cogwheelLearning]

Nice! I'm glad to hear that

[@venessoko1932]

Thankyou very much for this amazing short video✨

[@cogwheelLearning]

Thanks for watching! ❤️

[@Merrick117]

Big help! Thanks

[@cogwheelLearning]

Awesome 😎

[@jawadjohn8388]

Thank you, it was very helpful

[@cogwheelLearning]

I really appreciate your comment! ❤️

[@valirieserawop1858]

ok never mind I got it THANKS SO VERY MUCH!! I appreciate it.

[@cogwheelLearning]

Nice! 👌💪💪💪

[@aienjamir89]

Thank-you so much. Thankyou ❤

[@cogwheelLearning]

You're welcome 😊

[@nasrinkhan7104]

Thank you so much ❤

[@cogwheelLearning]

@@nasrinkhan7104 Thank You for choosing this video 🤗

[@arshiatalebi3217]

great video , keep it up

[@cogwheelLearning]

Thanks, will do!

[@fajarshaikh6979]

THANKS VERY HELPFUL

[@cogwheelLearning]

Congrats Fajar! You're the 100th person that thumbed up this video. ❤️❤️

[@priyankaingale3054]

Thank you so much sir for your help...you solved my problem🙂

[@cogwheelLearning]

Thanks for stopping by. I really appreciate it 💚

[@Happy_3435]

Veryyyy veryyy goood,,, thanks bro,, thanku sooooo much

[@cogwheelLearning]

❤️

[@lifeoflivy6643]

Thanks a lot…it worked

[@cogwheelLearning]

Amazing!

[@antoniobiscardi9838]

Thanks man great video

[@cogwheelLearning]

Thanks for watching. Please checkout my other videos as well. There are some hidden gems in there. 🤔

[@greenmango715]

Thank you very helpful

[@cogwheelLearning]

Thanks for the nice comment

[@greenmango715]

Your welcome .

[@HaVlogs]

GOD BLESS YOU SIR

[@cogwheelLearning]

And you 🙏

[@mcfallenmacha9611]

this is my best video on KZbin so far

[@cogwheelLearning]

Love it!

[@tonderaibangwayo6710]

Thank you so much

[@cogwheelLearning]

Always a pleasure

[@hiteshsabniiss1941]

Thanks mate...👍

[@cogwheelLearning]

Pleasure

[@Asgod7]

Thanks. Can you format an entire column to have multiple line?

[@cogwheelLearning]

I'm afraid that might not be possible because you would need to hit enter right before the word that you want on the next line and as far as I know there is no way to tell Excel to do that.

[@dannamatheus5172]

THANK YOU!

[@cogwheelLearning]

❤️

[@ashambo]

Thanks so much ❤❤❤❤

[@cogwheelLearning]

No problem 😊

[@karanpreetdhillon8035]

Its so useful

[@cogwheelLearning]

Thanks!

[@yvettemunezero5599]

Thank you

[@cogwheelLearning]

Pleasure. What were you trying to solve?

[@punkcatstv]

Thank you legend...

[@cogwheelLearning]

Let's gooo

[@eppoesau_mida]

Its good ...can you tell me how to do the same in android mobile app...excel spreadsheet

[@cogwheelLearning]

I haven't tested this yet, but you could try to: 1. Select the cell 2. Go to the formula bar 3. Start writing and add a new line as if you were texting on a regular app. It should work, but please let me know 😁

[@eppoesau_mida]

@@cogwheelLearning no its not working....

[@eppoesau_mida]

@@cogwheelLearning if you can please let me know immediately....and also using wrap text in excel sheet in android phones

[@cogwheelLearning]

@@eppoesau_mida hey, this should work then. At least on my phone it does. 1. Select the cell 2. Go to the formula bar and write your first line 3. On the formula bar, tap and hold for 2 seconds - > you should see a menu with an option called "New line" 4. Select the new line option

[@eppoesau_mida]

@@cogwheelLearning no..there was only paste copy cut &replace options

[@happy-station4155]

THank You !

[@cogwheelLearning]

You're welcome!

[@imhiteshd]

Thanks

[@cogwheelLearning]

Appreciate the comment!

[@eats.and.travels]

Thanks a lot👌👍

[@cogwheelLearning]

You got it

[@alejalbananaplanters-mpcba2174]

thank you a lot

[@cogwheelLearning]

Thanks for commenting. You're the man!👏

[@shahadathossainhimel939]

Thanks 🙏

[@cogwheelLearning]

My pleasure. A thumbs up would help tremendously

[@pedrocdo9599]

At the end of the video, how do you make it so that row 3 keeps the original size? I don't want it to expand every time.

[@cogwheelLearning]

If you mean that you don't want the row to expand horizontally, then you could use the Wrap Text feature on that cell. Here's a video explaining how to do that: kzbin.info/www/bejne/qaiZhoCEhbCjecU. Do let me know if this helps :D

[@saruulido1620]

THANK UUUUUUUUUUUUU

[@cogwheelLearning]

Yess!!

[@S10m648]

What if you want to undo those multiple lines?

[@cogwheelLearning]

That's a great question! Select your cell and try to position the cursor at the beginning of each line. Then press backspace and the line should be moved at the end of previous line. This has to be repeated for every line unfortunately

[@poojajadhav2705]

how can I add line between 1 & 2 sentences please help me

[@cogwheelLearning]

You can add ________ as a line in between. You can do that by pressing the same shortcut and just pasting your line. This should help ✌️

[@dilinisamarasinghe8678]

thanks

[@cogwheelLearning]

🤗

[@ritabrataghosh6765]

Please help me to do the same (alt & enter) in mobile phone

[@cogwheelLearning]

My colleague @HowXT explains this really well in this video: kzbin.info/www/bejne/qpDSe6Spo990esk

[@srinivasseena6574]

Great

[@cogwheelLearning]

;)

[@valirieserawop1858]

I did alt, but cant put the + without hitting the shift because it comes out to the = and changes it to a formula.

[@cogwheelLearning]

Interesting

[@Happy_3435]

U dont need to put + Just Alt enter

[@cogwheelLearning]

Exactly

[@subodh6988]

If my point 2 is of two lines then how to align it automatically

[@cogwheelLearning]

I'm afraid that might not be possible. Can you share what you're trying to achieve?

[@mybetterworks6918]

Thanx

[@cogwheelLearning]

No problem

[@DevilGamer-hc7fu]

Can You explain How To Delete 1 Row ?

[@cogwheelLearning]

You go to the row number on the left, left click and select delete row.

[@bayezero]

1:10 Video Start 🗿

[@cogwheelLearning]

Thanks for help 🦾

[@bayezero]

​@@cogwheelLearning Welcome 🌼

[@cogwheelLearning]

@@bayezero you're the man

[@sonalpriya6402]

Hey how to reverse that in cell?

[@cogwheelLearning]

Select your cell and try to position the cursor at the beginning of each line. Then press backspace and the line should be moved at the end of previous line. This has to be repeated for every line unfortunately

[@nayomikankanamge8137]

For MAC I GUESS IT SHOUD BE CTRL+OPTION+RETURN

[@cogwheelLearning]

Spot on!

[@yubarajmagar6250]

tq

[@cogwheelLearning]

Thanks for stopping by

[@kasimallanaresh5064]

Tnq

[@cogwheelLearning]

Thanks for stopping by! 😀

[@TheJokolila_]

doesnt help me

[@cogwheelLearning]

Why is that?

[@saja_elhaj]

Reeaallllllyyyy thankkksss🤍🤍🤍🤍🤍❤️❤️❤️❤️❤️❤️❤️❤️❤️

[@cogwheelLearning]

My pleasure ❤️

[@ankits2513]

It's not working for Mac

[@cogwheelLearning]

Control (ctrl) + Option (alt) + Return (enter) Please try the above

[@tonynguyen8976]

Thank you!

[@cogwheelLearning]

You are welcome

[@aniketkadam4394]

Thank you

[@cogwheelLearning]

Thanks for being here 🙏

[@HenryFamilyTheFirst]

Great

[@cogwheelLearning]

👍

[@jaccount8659]

Thank you!

[@cogwheelLearning]

🙏

[@addistube9550]

Thank you!

[@cogwheelLearning]

Thanks for stopping by 💜

[@ALF444]

Thanks

[@cogwheelLearning]

Thank YOU!