How to write multiple lines in one cell in Excel 😎

🔴 Checkout this playlist for more videos like this: • Playlist .
In this short video, you'll see how to write multiple lines of text within the same cell by using Microsoft Excel.
If you are on Windows the shortcut for this is ALT + ENTER and if you are on a MAC, the shortcut is COMMAND + OPTION.
When working in Excel, usually we write data on a single cell, but sometimes we have scenarios where we need to write multiple lines of text in the same cell, like when we're doing a todo list or when we have a massive project that with multiple tasks and we want to split those tasks across multiple lines while not using other cells.
Without using multiple cells, we could use ALT + ENTER when we're writing on a cell and immediately our cursor will be moved on a second line.
I hope this video is useful to you and if you learn something new, please hit the like button so we can reach and help more people for free. ❤️
Feeling generous? I like coffee.🤗
☕ www.buymeacoffee.com/cogwheel
If you're a beginner, start learning more about Excel with this free and awesome playlist where we explore different problems and scenarios in Excel: • Playlist .
Learn how to solve the #DIV? error: • 🚨 How to solve the #DI...
Keywords:
excel how to press enter without leaving the cell
how to write two lines in one cell in excel on macbook air
how to make two lines in one cell in excel mac
how to write 2 line in one row
how to write a line in two sentences in excel
how to write multiple lines in one cell macbook
how to write multiple lines in pc
insert multiple paragraphs in a cell in excel
how to press enter without leaving the cell
how to enter down in a cell
This video might be useful to you if you want to find out more about:
• how to write two lines in one cell ✅
• excel multiple lines in one cell ✅
• how to write multiple lines in one cell in excel ✅
• how to write in excel with two lines in one cell ✅
• excel wrap text multiple lines ✅
• how to type two lines in one cell ✅
• how to write two lines in one cell in excel ✅
• in excel how to make two lines in one cell ✅
• how to write multiple lines in one cell ✅
• excel ✅
• excel how to write multiple lines in one cell ✅
• multiple lines in one cell ✅
• how to write in excel ✅
• how to add line in excel ✅
• excel write in one cell multiple lines ✅
• how to add lines in excel ✅
• how to draw a line in excel ✅
• how to next line in excel ✅
• how to write multiline in one excel cell ✅
• how to write multiple lines in excel ✅
• excel enter text in one cell ✅
• excel line draw ✅
• excel multiple numbers in one cell ✅
• excel one cell two lines text ✅
• excel tutorial malayalam ✅
• excel wrap text ✅
• excel writing 2 lines in one cell ✅
• how to draw line in excel ✅
• how to draw line in excel cell ✅
• how to fit text in one cell ✅
• how to merge cells in excel ✅
• how to split cells in excel ✅
• how to type two lines in one cell in excel ✅
• how to write in excel in one cell ✅
• how to write two numbers in one cell excel ✅
• postman tutorial ✅
• split one cell into two rows in excel ✅
• split text in excel ✅
• two rows in one cell ✅
• 1 column two line number ms ✅
• 1-2 2-3 write in cell in excel ✅
• 2 answer in 1 cell excel ✅
• 2 cell in one line in excel ✅
• 2 line in one row in excel ✅
• 2 line merge one line excel ✅
• 2 lines 1 pol ✅
• 2 lines in a cell excel ✅
• 2 lines in one cell ✅
• 2 lines of text on 1 row on excel ✅
• 2 lines to write on burjpatra ✅

Пікірлер: 159

  • @baishnabidas1743
    @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

    @cogwheelLearning

    Жыл бұрын

    That's wonderful! ❤️

  • @cogwheelLearning
    @cogwheelLearning3 жыл бұрын

    I am creating KZread 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

  • @jujustateofmind5844
    @jujustateofmind58442 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    I appreciate you being here🙏

  • @briangonsalez2173
    @briangonsalez21732 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Nice!

  • @akshaysawant8035
    @akshaysawant8035 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks Akshay 🙏

  • @mariaboghean3047
    @mariaboghean30473 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    Thank you! Will do

  • @simonjosefsson1419
    @simonjosefsson1419 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thank you so much sir🙏

  • @dominikmozes6569
    @dominikmozes65693 жыл бұрын

    Great Video! Thanks for the quick info!

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    My pleasure. 😇

  • @shanks9926
    @shanks99268 ай бұрын

    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

    @cogwheelLearning

    8 ай бұрын

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

  • @MiuArtStudioUK
    @MiuArtStudioUK2 жыл бұрын

    Thank you :) the quick version made me smile

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Awesome 😍

  • @pamelaboggs222
    @pamelaboggs222 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Wouldn't wanna waste your precious time 🙏

  • @venessoko1932
    @venessoko19323 жыл бұрын

    Thankyou very much for this amazing short video✨

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    Thanks for watching! ❤️

  • @blessedhoney8512
    @blessedhoney85122 жыл бұрын

    So short and useful, thank you.

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

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

  • @lindascoon4652
    @lindascoon46523 жыл бұрын

    Thank you for getting straight to the point

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

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

  • @Nemisreyd
    @Nemisreyd Жыл бұрын

    perfect ! You've got my appreciation

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thank you! A thumbs up will help

  • @E52Matt
    @E52Matt3 жыл бұрын

    Thanks so much so easy to follow and so helpful

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    I really appreciate your comment, Elise! ❤️

  • @Patty_Eli
    @Patty_Eli Жыл бұрын

    Thank you! Short and sweet!

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    You're very welcome 🤗

  • @evelyngocela6673
    @evelyngocela6673Ай бұрын

    Thanks you Bro. short and precise

  • @cogwheelLearning

    @cogwheelLearning

    Ай бұрын

    That's how we like it 🎉

  • @dannykwak3433
    @dannykwak3433 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

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

  • @jawadjohn8388
    @jawadjohn83882 жыл бұрын

    Thank you, it was very helpful

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    I really appreciate your comment! ❤️

  • @manutotheworld8889
    @manutotheworld888910 ай бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    10 ай бұрын

    Nice!

  • @Super_Saiyan_Rainbow
    @Super_Saiyan_Rainbow Жыл бұрын

    Thank you!

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thank you Mr. Saiyan!

  • @Merrick117
    @Merrick1178 ай бұрын

    Big help! Thanks

  • @cogwheelLearning

    @cogwheelLearning

    8 ай бұрын

    Awesome 😎

  • @lifeoflivy6643
    @lifeoflivy6643 Жыл бұрын

    Thanks a lot…it worked

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Amazing!

  • @nikkibiswal5375
    @nikkibiswal53752 жыл бұрын

    Thanks. Precise and helpful

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

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

  • @naphychileshe6123

    @naphychileshe6123

    2 жыл бұрын

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

  • @arshiatalebi3217
    @arshiatalebi32175 ай бұрын

    great video , keep it up

  • @cogwheelLearning

    @cogwheelLearning

    5 ай бұрын

    Thanks, will do!

  • @antoniobiscardi9838
    @antoniobiscardi98382 жыл бұрын

    Thanks man great video

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

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

  • @aienjamir89
    @aienjamir8911 күн бұрын

    Thank-you so much. Thankyou ❤

  • @cogwheelLearning

    @cogwheelLearning

    11 күн бұрын

    You're welcome 😊

  • @priyankaingale3054
    @priyankaingale30542 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Thanks for stopping by. I really appreciate it 💚

  • @thelivereactions
    @thelivereactions5 ай бұрын

    Thanks u r very quick in solving problems 🎉

  • @cogwheelLearning

    @cogwheelLearning

    5 ай бұрын

    Thanks! How did the video helped you?

  • @thelivereactions

    @thelivereactions

    5 ай бұрын

    @@cogwheelLearning alt + enter 😃

  • @cogwheelLearning

    @cogwheelLearning

    4 ай бұрын

    Nice! I'm glad to hear that

  • @nasrinkhan7104
    @nasrinkhan710424 күн бұрын

    Thank you so much ❤

  • @cogwheelLearning

    @cogwheelLearning

    24 күн бұрын

    @@nasrinkhan7104 Thank You for choosing this video 🤗

  • @valirieserawop1858
    @valirieserawop18582 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Nice! 👌💪💪💪

  • @ChallengerRhino
    @ChallengerRhino3 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    Yeah, the Like button was really asking for it

  • @karanpreetdhillon8035
    @karanpreetdhillon8035 Жыл бұрын

    Its so useful

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks!

  • @fajarshaikh6979
    @fajarshaikh69792 жыл бұрын

    THANKS VERY HELPFUL

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

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

  • @greenmango715
    @greenmango715 Жыл бұрын

    Thank you very helpful

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks for the nice comment

  • @greenmango715

    @greenmango715

    Жыл бұрын

    Your welcome .

  • @hiteshsabniiss1941
    @hiteshsabniiss1941 Жыл бұрын

    Thanks mate...👍

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Pleasure

  • @tonderaibangwayo6710
    @tonderaibangwayo6710 Жыл бұрын

    Thank you so much

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Always a pleasure

  • @ashambo
    @ashambo Жыл бұрын

    Thanks so much ❤❤❤❤

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    No problem 😊

  • @Happy_3435
    @Happy_34352 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    ❤️

  • @dannamatheus5172
    @dannamatheus51722 жыл бұрын

    THANK YOU!

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    ❤️

  • @punkcatstv
    @punkcatstv Жыл бұрын

    Thank you legend...

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Let's gooo

  • @happy-station4155
    @happy-station4155 Жыл бұрын

    THank You !

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    You're welcome!

  • @HaVlogs
    @HaVlogs Жыл бұрын

    GOD BLESS YOU SIR

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    And you 🙏

  • @alejalbananaplanters-mpcba2174
    @alejalbananaplanters-mpcba2174 Жыл бұрын

    thank you a lot

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks for commenting. You're the man!👏

  • @yvettemunezero5599
    @yvettemunezero559922 күн бұрын

    Thank you

  • @cogwheelLearning

    @cogwheelLearning

    22 күн бұрын

    Pleasure. What were you trying to solve?

  • @eats.and.travels
    @eats.and.travels2 жыл бұрын

    Thanks a lot👌👍

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    You got it

  • @saruulido1620
    @saruulido1620 Жыл бұрын

    THANK UUUUUUUUUUUUU

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Yess!!

  • @shahadathossainhimel939
    @shahadathossainhimel939 Жыл бұрын

    Thanks 🙏

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    My pleasure. A thumbs up would help tremendously

  • @pedrocdo9599
    @pedrocdo95993 жыл бұрын

    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

    @cogwheelLearning

    3 жыл бұрын

    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: kzread.info/dash/bejne/patqt6-HgK7Wc8Y.html. Do let me know if this helps :D

  • @dilinisamarasinghe8678
    @dilinisamarasinghe8678 Жыл бұрын

    thanks

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    🤗

  • @mcfallenmacha9611
    @mcfallenmacha9611 Жыл бұрын

    this is my best video on KZread so far

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Love it!

  • @ALF444
    @ALF4442 жыл бұрын

    Thanks

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Thank YOU!

  • @srinivasseena6574
    @srinivasseena65745 ай бұрын

    Great

  • @cogwheelLearning

    @cogwheelLearning

    5 ай бұрын

    ;)

  • @Asgod7
    @Asgod710 ай бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    10 ай бұрын

    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.

  • @mybetterworks6918
    @mybetterworks69186 ай бұрын

    Thanx

  • @cogwheelLearning

    @cogwheelLearning

    6 ай бұрын

    No problem

  • @yubarajmagar6250
    @yubarajmagar6250 Жыл бұрын

    tq

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks for stopping by

  • @eppoesau_mida
    @eppoesau_mida3 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    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

    @eppoesau_mida

    3 жыл бұрын

    @@cogwheelLearning no its not working....

  • @eppoesau_mida

    @eppoesau_mida

    3 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    3 жыл бұрын

    @@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

    @eppoesau_mida

    3 жыл бұрын

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

  • @ritabrataghosh6765
    @ritabrataghosh6765 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    My colleague @HowXT explains this really well in this video: kzread.info/dash/bejne/ppOjrNOsnt2ndMo.html

  • @valirieserawop1858
    @valirieserawop18582 жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Interesting

  • @Happy_3435

    @Happy_3435

    2 жыл бұрын

    U dont need to put + Just Alt enter

  • @poojajadhav2705
    @poojajadhav2705 Жыл бұрын

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

  • @cogwheelLearning

    @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 ✌️

  • @kasimallanaresh5064
    @kasimallanaresh50642 жыл бұрын

    Tnq

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Thanks for stopping by! 😀

  • @subodh6988
    @subodh69886 ай бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    6 ай бұрын

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

  • @DevilGamer-hc7fu
    @DevilGamer-hc7fu Жыл бұрын

    Can You explain How To Delete 1 Row ?

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

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

  • @nayomikankanamge8137
    @nayomikankanamge8137 Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Spot on!

  • @bayezero
    @bayezero Жыл бұрын

    1:10 Video Start 🗿

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks for help 🦾

  • @bayezero

    @bayezero

    Жыл бұрын

    ​@@cogwheelLearning Welcome 🌼

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    @@bayezero you're the man

  • @saja_elhaj
    @saja_elhaj Жыл бұрын

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

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    My pleasure ❤️

  • @TheJokolila_
    @TheJokolila_ Жыл бұрын

    doesnt help me

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Why is that?

  • @ankits2513
    @ankits2513 Жыл бұрын

    It's not working for Mac

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

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

  • @tonynguyen8976
    @tonynguyen897614 күн бұрын

    Thank you!

  • @cogwheelLearning

    @cogwheelLearning

    14 күн бұрын

    You are welcome

  • @aniketkadam4394
    @aniketkadam43942 жыл бұрын

    Thank you

  • @cogwheelLearning

    @cogwheelLearning

    2 жыл бұрын

    Thanks for being here 🙏

  • @HenryFamilyTheFirst
    @HenryFamilyTheFirst Жыл бұрын

    Great

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    👍

  • @jaccount8659
    @jaccount8659 Жыл бұрын

    Thank you!

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    🙏

  • @addistube9550
    @addistube9550 Жыл бұрын

    Thank you!

  • @cogwheelLearning

    @cogwheelLearning

    Жыл бұрын

    Thanks for stopping by 💜