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

Поділитися
Вставка
  • Опубліковано 17 гру 2024

КОМЕНТАРІ • 816

  • @TeachExcel
    @TeachExcel  3 роки тому +22

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

  • @betsyikeme1972
    @betsyikeme1972 3 роки тому +466

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

    • @micky469
      @micky469 3 роки тому

      Thank you soo much.. We learn everyday

    • @dStrojdStroj
      @dStrojdStroj 3 роки тому +1

      @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
      @thicksauceism 3 роки тому +1

      I could relate lol

    • @ichigo3794
      @ichigo3794 3 роки тому +1

      Literally!!!! Lol

    • @mihaly1555
      @mihaly1555 3 роки тому +1

      Same lol

  • @amaltijarah6561
    @amaltijarah6561 5 років тому +67

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @gossienworu3210
    @gossienworu3210 2 роки тому +14

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

  • @thescienceandengineeringco4079
    @thescienceandengineeringco4079 2 роки тому +5

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

  • @xPawful
    @xPawful 11 років тому +108

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

  • @loneshadow0844
    @loneshadow0844 3 місяці тому +1

    14 years ago and still it helps on the free Excel. Thank you channel from the past to help in the dire need.

  • @cruzgonzalez5276
    @cruzgonzalez5276 5 років тому +6

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

  • @nadsalman7881
    @nadsalman7881 4 роки тому +11

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      See ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @nicholegilbert1717
    @nicholegilbert1717 3 роки тому +7

    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
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

    • @JavedSidiqi
      @JavedSidiqi Рік тому +1

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

  • @landofimPatience
    @landofimPatience 10 років тому +33

    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
      @Lee-AnneJ 7 років тому

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

    • @kaylawilliamsmehr2788
      @kaylawilliamsmehr2788 4 роки тому

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      See ua-cam.com/video/twxNznfO3nk/v-deo.html

    • @Jaiii_Tee
      @Jaiii_Tee 3 роки тому

      Thank you

  • @fevo69
    @fevo69 16 днів тому

    Thank you for your help, and thank you for your time and
    dedication in making and posting this video on YT, for everyone to learn something new about Excel.

  • @SP-og5uz
    @SP-og5uz 4 місяці тому +1

    Awesome. Quick, easy, to the point, nice voice AND it worked like a charm. Good job!

  • @MindFixer75212
    @MindFixer75212 3 роки тому +9

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @zahidshad6194
    @zahidshad6194 10 місяців тому +1

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

  • @Grandmaster-
    @Grandmaster- 2 роки тому +2

    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.

  • @JavedSidiqi
    @JavedSidiqi Рік тому

    It took me two days and multiple searches to find this one option alt+enter... thank you so much...

  • @matthew10502
    @matthew10502 2 роки тому +1

    Not all hero wear capes, but you sir where have you been in all my life. Thank you so much for doing this man :)

  • @abujaberrizvy8087
    @abujaberrizvy8087 14 годин тому

    15 years, and still helpful.

  • @esme5111
    @esme5111 3 роки тому +4

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @nahasmoothedath2341
    @nahasmoothedath2341 Рік тому

    Thank you. After 13 years I got benefit of this video

  • @ne5409
    @ne5409 2 роки тому

    Thanks!!!!!! I used to recall this, but after not using Excel for over a year it slipped my mind.

  • @sivasankar566
    @sivasankar566 Рік тому +1

    After 13 years this video saving me today from the work in Excel, thank you so much ❤️ for this video by in ( India) Feb 22 2022

  • @namutebiruth8182
    @namutebiruth8182 6 місяців тому

    My dia... May God increase you in knowledge... Thank you. You saved this soul of mine

  • @Kazi_Sazzad
    @Kazi_Sazzad 2 роки тому

    After 12 Years Your video saves my time..Thank you.

  • @jimmahanes
    @jimmahanes Рік тому

    Thanks ... I love these videos that make you sit through minutes of crap to get around to answering my question that could have been done in 5 seconds.

  • @som956
    @som956 9 місяців тому

    14 years later, still very USEFUL, thank you !

  • @FlyingGreenTea
    @FlyingGreenTea 7 місяців тому

    After 15 years, this has helped me a lot in 2024!
    I hope you are doing well. Thank you so much!

  • @kingsleyukaulor3704
    @kingsleyukaulor3704 3 роки тому

    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
      @relaxtv584 3 роки тому

      See ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @insaneguy1197
    @insaneguy1197 День тому

    15 years later, and this is still useful!

  • @muskanceleste
    @muskanceleste 3 роки тому

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

  • @oshorakporbecky9318
    @oshorakporbecky9318 7 місяців тому

    Thank you sir for posting this
    Since 14yrs ago and it’s just helped me out in my assignment 🙏🙏🙏

  • @SpaceCadet4Jesus
    @SpaceCadet4Jesus 3 роки тому +1

    If you don't use it, you lose it. Thanks for re-educating me after decades.

  • @aortiz1986
    @aortiz1986 10 років тому +7

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @ninjapirate123
    @ninjapirate123 11 місяців тому

    I didn't know this until I watch your video, thanks so much. But it's crazy that it's this simple

  • @rashacaliman1298
    @rashacaliman1298 Рік тому

    13 years later and you definitely saved the day!
    Thank you 🙌🏾

  • @dimitrisoikonomou3568
    @dimitrisoikonomou3568 Рік тому +1

    I could tell that people at work were laughing at me when my boards with text were only in line because of spacebar and wrap up text.
    One step closer on being a professional thanks to you!!
    Thank you!!

  • @wailabdalla9622
    @wailabdalla9622 2 місяці тому

    You have no idea how much this helped, thank you

  • @Mohamed-Samy967
    @Mohamed-Samy967 Рік тому

    13 years later you saved me ,thanks man

  • @NoNameFoundHere999
    @NoNameFoundHere999 6 місяців тому

    Omagosh thank you so much 😭 you're a saviour even after so many years 😭😭😭

  • @BarryWraps
    @BarryWraps 10 років тому +7

    thanks, this just saved my grade in my history class

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @pedrog.moreira2014
    @pedrog.moreira2014 Рік тому

    Never in my life I imagined to be learning excel tips with Matthew McConaughey

  • @basemahassan3933
    @basemahassan3933 2 роки тому +1

    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

  • @hageankha5952
    @hageankha5952 5 днів тому

    Was desperately searching for this. Thankyou man..

  • @hollychaffee606
    @hollychaffee606 Рік тому

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

  • @habiebiee1
    @habiebiee1 11 років тому +3

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

  • @x6ryy
    @x6ryy 2 роки тому +1

    yo this helped so much thanks man, been 12 years

  • @jagadeesanp4517
    @jagadeesanp4517 4 роки тому +1

    Thanks sir, just now i see this your (11 years back created video) it will clear my problem creating excel table.

    • @relaxtv584
      @relaxtv584 3 роки тому

      See ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @abdullah00-w5o
    @abdullah00-w5o 2 роки тому

    Thank you 💞 after 12 years this video help me a lot 💞

  • @pattyg982
    @pattyg982 Рік тому +3

    On Mac it's Option + Return. But, how do you get the horizontal lines closer together? See how much spacing is between the first line of text and the second line of text?

  • @ptnewman2674
    @ptnewman2674 8 років тому +11

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

  • @selder_7
    @selder_7 11 місяців тому +1

    Forever forgetting it’s Alt+Enter instead of shift or CTRL, thank you

  • @marvelade3606
    @marvelade3606 2 роки тому +3

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

  • @marcoslpires
    @marcoslpires 3 роки тому

    Saved my life!!! Thaks! I should have seen this video years ago!

  • @adityasaha2738
    @adityasaha2738 6 місяців тому

    Thanks after 14 years!! It helps❤

  • @JanellAlysse
    @JanellAlysse 7 років тому

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

  • @ahmedtahir8484
    @ahmedtahir8484 2 роки тому

    THANK YOU SOO MUCH!!
    SAVED MY LIFE BEORE MY PRACTICAL EXAM

  • @swone6349
    @swone6349 2 роки тому

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

  • @sergeantrecker3639
    @sergeantrecker3639 4 роки тому +4

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @artdovector6731
    @artdovector6731 6 місяців тому

    It's my long time trouble. Now problem solved by you. Thank you so much sir

  • @gabriellamayyyyyyy_2003
    @gabriellamayyyyyyy_2003 Рік тому +1

    Thank you very much! It's 13 years ago but still helpful.

  • @syedrahman4096
    @syedrahman4096 Рік тому

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

  • @amirulhazimamrin2045
    @amirulhazimamrin2045 2 роки тому +1

    12years later, and still benefits much people 😍

  • @mohdzariqlutfi3335
    @mohdzariqlutfi3335 Місяць тому

    Thanks a lot for your great 14 years ago video...🤩

  • @beastyfeast8933
    @beastyfeast8933 6 місяців тому

    What an old school I am for needing to watch this video after 14 years

  • @ovaistauheed
    @ovaistauheed 9 років тому +1

    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
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @ericgrusing9197
    @ericgrusing9197 5 років тому

    Quick and Easy thanks was looking at all formatting etc.. should have came here first. Thanks

  • @shabufanasirmim631
    @shabufanasirmim631 4 місяці тому

    Thanks a lot after 14 years ❤

  • @MarckConrado
    @MarckConrado Рік тому

    GOATTTTTTT W VID. Needed this for my bio lab final

  • @pattietempleton7580
    @pattietempleton7580 4 роки тому +4

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @kyalifnoronha2443
    @kyalifnoronha2443 3 роки тому

    Ngl after clg I thought I knew most things about excel until I faced this, thanks to you... Got saved from embarrassing myself 😅😄

  • @fordjanakpurshowroomgoford6267
    @fordjanakpurshowroomgoford6267 5 років тому

    UR VIDEO IS SO CLEAR TO UNDERSTAND NOT LIKE OTHERS THANKS

  • @100PercentOS2
    @100PercentOS2 4 роки тому +3

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

  • @staceem
    @staceem 7 років тому +2

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @jamestalla1426
    @jamestalla1426 2 роки тому

    Thanks a million 🙏🙏 12 years later it still helps😊

  • @davidmok108
    @davidmok108 3 роки тому

    in year 2021, your video still helping people, great thanks!

  • @laurenross-z8h
    @laurenross-z8h Рік тому +1

    Thanks this saved me today at work

  • @fatinussarahjamil3682
    @fatinussarahjamil3682 3 роки тому

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

  • @faresalaa4562
    @faresalaa4562 2 роки тому +1

    12 years later and this still useful

  • @egang1920
    @egang1920 Рік тому

    Thank you after 13 yrs you solved my three month problem

  • @harshadbandkar4148
    @harshadbandkar4148 2 роки тому

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

  • @faithfullysubmittedwithMsDee

    Here it is 2022 and this just saved my reports.😅… I’ve been trying to figure this out.. Thank you Sir! God Bless you.

  • @mrCetus
    @mrCetus 2 роки тому +13

    Since you can have up to 32,767 characters in an Excel cell, you could turn a spreadsheet into a compact, basic note-taking app. Just extend the formula bar and you have a large area to fill with text.

  • @Krishna-ui6wp
    @Krishna-ui6wp 6 років тому

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

  • @junaidmuhammad996
    @junaidmuhammad996 3 роки тому

    Lovely video I was looking for this from long time. Love you man

    • @relaxtv584
      @relaxtv584 3 роки тому

      See ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @al-krimaralias9356
    @al-krimaralias9356 3 роки тому

    My man, you just save my mood. Thanks.

  • @moneymanjoe9639
    @moneymanjoe9639 3 роки тому

    Instant sub my man. I was going crazy trying to figure this out.

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @anjalimaity6743
    @anjalimaity6743 3 роки тому +1

    It was very important for me to know, thank you.thank you
    .thank you

    • @TeachExcel
      @TeachExcel  3 роки тому +1

      You are very very very welcome :)

  • @Mr_Robinhood_4_u
    @Mr_Robinhood_4_u 2 роки тому +1

    11 years ago wov amazing dear tech Excel 🥰

  • @Missony74
    @Missony74 4 роки тому +2

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

  • @abdiqanimohamudhashi3945
    @abdiqanimohamudhashi3945 3 роки тому

    Thank you very much for teaching me to fix my problems

  • @John3K21
    @John3K21 7 років тому

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @Vasco7984
    @Vasco7984 Рік тому

    Wowwww. Just like that; you saved me pal.
    Thanks a lot mate

  • @abdulaziz-montana
    @abdulaziz-montana 11 років тому +13

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

    • @relaxtv584
      @relaxtv584 3 роки тому

      ua-cam.com/video/twxNznfO3nk/v-deo.html

  • @tommyhatfield2882
    @tommyhatfield2882 2 місяці тому +2

    14 years later... Thanks

  • @модестгаврилов
    @модестгаврилов 2 роки тому

    Thank you! You have saved my nerve cells

  • @ChauhanJiVlogs007
    @ChauhanJiVlogs007 Рік тому

    Thanks ... I learnt this in 1st year in TCS

  • @classxstudent4310
    @classxstudent4310 Рік тому

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

  • @beniezung4611
    @beniezung4611 2 роки тому +1

    2022.. U saved so much of my time. Thank you🌹

  • @lomajakun6566
    @lomajakun6566 2 роки тому

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