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

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

@micky469

3 жыл бұрын

Thank you soo much.. We learn everyday

@dStrojdStroj

2 жыл бұрын

@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

2 жыл бұрын

I could relate lol

@ichigo3794

2 жыл бұрын

Literally!!!! Lol

@mihaly1555

2 жыл бұрын

Same lol

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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

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.

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

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

@JavedSidiqi

7 ай бұрын

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

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

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

@FranklynGrant

9 жыл бұрын

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

@traxinternational622

6 жыл бұрын

xPawful thank you

@christab3972

6 жыл бұрын

THANK YOU!!!!!

@renukhera7028

5 жыл бұрын

thanx xpawful

@AvantiMorocha1

5 жыл бұрын

Thank you :)

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

@relaxtv584

2 жыл бұрын

See kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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?

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

@aienjamir89

6 күн бұрын

Sameeeee

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

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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

2 жыл бұрын

See kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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

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

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

Lifesaver so happy to find this subscribed !!

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

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

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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.

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

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

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

But how to make lines apear below each row? I want to make a blank of document with lines.

Hi. Thank you for this video. 😊 Do you know how I can separate text into individual rows and cells? I work on a Spreadsheet where my department has it set up with the multiple lines within one cell, but I need to count only certain data. Countif won't work, nor will filter in this format. What's worse is I am looking for specific names with certain criteria. Example, how names might be listed in the cells by column throughout the spreadsheet: N: George/Amy*/Adam N: George N: Adam*/George (Each one of these will be in their own cell with multiple lines of additional data.) I used the asterisk to represent a bolded name. Let's say I'm counting for George. I would only count him once because, although he is listed in a group of other names, I only count him if he is in bold or on a line by himself. Is there any way I can split the cell so all data moves to its own row? If I can make that happen, then I could sort. This spreadsheet is difficult because it's pretty big, especially with all the large cells that have multiple lines within one cell. I have no idea what else to do. I'd appreciate any guidance! Thank you!

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

hi. is there any way to do that to cells written before. because i have a long list

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

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

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

i have 500 lines of info in excel, where i to need to insert 20 sub-lines from every mainline. Can do it in one go, or i need to create one by one? pls advise

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

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

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

@TeachExcel

2 жыл бұрын

You're very welcome!:)

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

Cleared my one specific doubt so easily. Thanks much 🌷

Sir how to separate phone numbers which r in a para and separated by commas, but how can i make them in vertical form , like in separate cells

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

7 жыл бұрын

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

@kaylawilliamsmehr2788

4 жыл бұрын

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

@relaxtv584

2 жыл бұрын

See kzread.info/dash/bejne/pqussNynlrKZns4.html

@Jaiii_Tee

2 жыл бұрын

Thank you

UR VIDEO IS SO CLEAR TO UNDERSTAND NOT LIKE OTHERS THANKS

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

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

Will you be able to explain how to add second line in the same cell on ipad

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

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

Just what I needed to know! Thank you~

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

I have a followup question that I can't seem to get worded right, in order to find the answer. Now that I've done this step and I've created multiple lines in Column A. All of the other columns for Line 1 have multiple lines in them as well. How do I type on those lines in column b, c, d etc. Say I have 3 lines created in Column A Line 1, when I move over to column b and attempt to type, I cannot access the higher lines and if I use ctrl+enter, it adds a 4th or 5th line.

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

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

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

14 years later, still very USEFUL, thank you !

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

thanks, this just saved my grade in my history class

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

If data is already prepare can we do this in multiple row 1 column. .

Now if i want to assign the value for one of the line from one column to onother how is it possible

Can I change alignment on the 2nd line? Ex. 1st line is centered, 2nd line I wanna do flush left.

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

Can we give sequential number to each line in a cell using any formula?

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

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

Thank you very much. This was really helpful

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

Thank you so much! It really helped!

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

Thanks bruh! You're the best!

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

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

Thank you soo much for shared , this video really helped me for solved one of my issue..

How about for iPad Pro excel? These shortcuts aren’t working for me

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

@smijilchirayil2431

Жыл бұрын

Great

This was very helpful and straightforward. Thank you.

@relaxtv584

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

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

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

DUDE!!! YOU HELPED ME! THANK YOU!

Is there a way to reverse that process, so to split multiple lines of text in one cell, into multiple rows?

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

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

Thank you very much for teaching me to fix my problems

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

@SM10170

Жыл бұрын

Teri

Thanks! On the Mac, I found out you have to hold down both the OPTION and COMMAND keys and press Return (Enter).

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

2 жыл бұрын

kzread.info/dash/bejne/pqussNynlrKZns4.html

Thank you so much. It really helped me🎉

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

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

Thank you very much for sharing this information

Amazing!! it works. Thanks to you.

Please let us know any formula for this trick with concatenate and transposed formula

Thanks for the useful information, perfect explanation