The QUICKEST & EASIEST Way to Work with TEXT in Excel (Fill Justify)
HTML-код
- Опубликовано: 28 авг 2019
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover the hidden gem of Excel - the 'Justify' feature. This tutorial is a part of the Excel Essentials, aimed at making your Excel experience smoother and more efficient.
🎓 Get access to the Excel Essentials Course 👉 www.xelplus.com/course/learn-...
🔑 What You'll Learn:
▪️ Ease of Using Fill Justify: Learn how the Justify feature can automatically adjust text within a specified column width, saving you the tedious task of manual editing.
▪️ Creating Cleaner Instruction Sheets: Understand how to make your instruction sheets look more professional with minimal effort.
▪️ Adaptable Text Flow: Find out how to effortlessly modify and rearrange text blocks to fit your layout needs.
You can do that with Excel's Fill Justify feature. With ONE click you can properly align and arrange your text in a readable format. Justify automatically cuts the overflowing text and pastes it in the cells below. It also works the other way round. You can bring text from multiple rows in one single cell!
** Watch Out for Excel's 255 character limit: If your first cell has text with more than 255 characters and you Fill Justify down - then the remainder of the text is deleted.
You DON'T run into a problem if you Justify text from multiple columns to one cell - Excel puts the remainder on the row below.
⯆ Blog Post: www.xelplus.com/microsoft-exc...
LINK to Excel TIPS & HACKS playlist: • Excel Hacks: Tips & Tr...
LINK to Excel basics playlist: • Excel Introduction - L...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Get access to the full Excel Essentials course here 👉 www.xelplus.com/course/learn-excel-essentials/
thank you. it really helps me
20 year user of excel. Never heard of this. Magic!!
I use text boxes - but this is much better.
Thanks and keep up the awesome videos
Took me a long time to find it too :)
Been using Excel since 1993(Ver.5) & never knew about this. Thanks!
I've been staring at it for years myself while I was cutting and pasting ... :)
Anyone who has worked with excel may occasionally come across long sentences so this idea is wonderful I like it . Thanks Leila.
I want to call this VIDEO OF THE MONTH. Such an amazing useful trick. The short cut key for this (well no that short cut) is ALT+H+F+I+J. Justifying the Unjustified.... LOL. Lovely Leila :
Thanks for that Sachin 😘
OMFG!! Sorry that I can not tell You how much time this saves me.. I very often write instructions for safely disconnecting high voltage distribution network. For some reason the template is made in excel, but most information is in text... This is going to be great! Love You! ;)
I can totally relate Thomas. I write a lot of instructions too :) Glad it's helpful for you.
You are kidding me. I consider myself an advanced Excel user, and never heard of that before. Thank you!!!
I had the same reaction :)
Thanks, love you videos. Cool feature for a few lines that I never knew about!
Personally, I just merge the cells and use wrap text. This works well for longer text as well and allows me to apply formatting such as justification for neat paragraphs.
Totally agree - it is one of the best tricks in Excel for Text: Alt, E, I , J
That's great! Thank you for the shortcut teammate Mike : )
EXCELLENT! I had been messing around with the slow, old, awkward way of doing it for years.
Who knows how much time you have saved me with this 3-minute video!
Thanks.
I've been doing it myself for years :)
Hi Leila, thanks for this information. The Fill / Justify works like a charm. One limitation though is that it tends to work for up to 255 characters. At least that's what I'm running into using Excel 365.
So simple... So useful!
Thanks Sheila.
I've been using Excel since 1992, almost never had the need to cut and paste text to the next line, but indeed when I did, I did it just like you. But this is really useful. Thx for that!
Glad you find it useful too. It's really a time saver for me.
Really helpful. Thank you!
Man i love you girl !!!! Lol ... i have all this time been doing the old school way as per your opening. Thank you i am now wiser because of you Leila.!!! Thanks.
Imagine having 350K subscribers just from making Excel courses. This speaks volumes about the quality of your video's! Thank you
Looked for this for so long. thank you!
Thank you! I have been looking for this for so long.
What an excellent hint! Thank you
Concise & To The Point As Always... ❤
Hidden tip, indeed. I had learned that a while ago but had forgotten it and couldn't find it anywhere - until now. Thank you very much, Leila.
Our pleasure :)
Damn Leila! This will help me a lot. I write a lot of instructions for my techs and I have come across that very issue countless times, Thanks much for your well done video.
Great tip! Thanks.
Good tip ! Thank you !
Thanks for all your educational video tips and tricks
Perfect.... More of these capsules would be highly appreciated.👍👍
I'll try my best Neeraj :)
That's amazing, Leila! I used a text box for instructions or would wrap text in a cell, but 'Justify' will be definitely useful. Thanks for sharing this.
For me this way works better and is neater. Hope it will be useful for you too.
Great video. Thanks!
Simply awesome, thank you!
Indeed useful, thank you
very useful tip. Thank you.
Thanks for the great tip!
Amazing and very usefull.Thank you!
great tip!
I am speechless. And very happy for now knowing this. Thanks a LOT, Leila!
My pleasure Celia :)
This is a time saver tip. Thanks for sharing. Looking forward for more tips.
It definitely is for me. Glad you like it.
Excellent!
Very Useful
Wow! Thanks Leila.
Very useful again, thank you! :)
Awesome hidden feature!!
Fantastic!
Thank you for your support.
Amazing 🙂 thanks for sharing!
My pleasure Malina. Glad you like it.
Great as usual! Thanx
so simple, and yet so amazing. this is going to save me tons of time now. thanks leila
That's great. Saves me a lot of time too :)
Amazing !!! Thanks for sharing !!!
You're very welcome Victor. Hope it will come in handy.
Thank you so much Leila. That is so useful and helpful. 👍
You're very welcome. Glad you like it.
I was looking for this solution
Thank you :)
I'm glad I could help with that :)
Great example for this useful feature!
Thanks Doug, glad you like the video.
Leila ,This is awesome!!
Brilliant. I've needed this forever. Thanks!
Took me a long time to find it too :)
Thanks, had literally forgotten about this simple yet helpful feature. Cheers!
Yes, it can really be beneficial.
I was using Excel for many year, I didn't know about this application. Thanks Leila you save my day!
It was the same for me :)
Beautiful!
thanks for the tips
You're very welcome. Hope it's useful.
always great
Thank you so much for this wonderful tip Leila.
Very useful stuff as always. :)
You're very welcome Luis. Glad you find it useful.
Thank you Leila for these wonderful ideas, and you remain the queen of Axel and his witch
Excel witchcraft ... I like that :)
Thanks for video!
You#re very welcome. Hope it's useful for you.
Thanks Leila, very helpful.
You're very welcome. Glad it's useful.
thanks. it helps me a lot
Awesome tip 👍...thank you so much for this information
You're very welcome. Glad you like the little trick.
That's very useful. Thanks!
My pleasure. Glad you like it.
SUPERB!
Thanks Leila! Magic indeed.
It's Excel witchcraft Richard :)
Wow, thank you 💯👋👋👋
Thank you very much Leila
Fantastic. Wish I knew this earlier. Thank you.
My pleasure Joshua. Took me a while too ... :)
Thank you leila❤️
Wooowww....it's great and very helpful. Thank you Leila's. I love this channel.
It's great to have you here :)
Great tip, reduces the need for text boxes and shapes to contain text.
Exactly. Saves me so much time now.
Brilliant ! Thanks
Glad you like it.
Amazingly easy.... thank you always....
It is, once you know about it :)
You're awesome. I was always facing this problem. Thanks for this useful video.
I can very well relate :) Glad it's useful for you.
Awesome , thank you so much
Thanks for that helpful pointer Leila 👍
You're very welcome. Hope it will come in handy.
:-O How is it possible that I didn't know this?! I am once again humbled by you, Leila. Thank you!
Took me a LONG time too ... :)
But it did not work if the text has much characters. It only works on a certain number of characters.
So amazing, i have never though we can do with this simple funtion. Thank you so much
My pleasure. Glad you like it.
Thank you so much.
This will be a useful one for me.
Great tips.
My pleasure. I'm glad to hear it's useful.
Thnx a lot to educate us.
You're very welcome.
Very good tip 👍😀 Thank you.
My pleasure. I'm glad you like it.
Magical!!! Thanks a lot.
You're very welcome Jean. Glad you like my witchcraft :)
*_I needed this feature ever since. Thank you so much, Leila._*
You're very welcome Mark. Glad it's useful for you.
@@LeilaGharani *_Absolutely. Please make more of these SIMPLE tips and tricks we never knew existed. Thanks again much._*
that was GREAT!!
I'm glad to hear that. Hope it will come in handy.
Leila, thanks so much for that excel tip. It was very helpful in my everyday excel task.
You're very welcome Steven. Glad it's helpful for you.
Superuseful !!
That's great, I was using cut paste way for the last 10 years. Thankyou
Happy to help :)
Wow a great find. Have always used alt+enter and extended the cell
Glad you like it Peter. For me this is easier and more efficient.
Great. will look forward to viewing it
Great tip. You posts help me no end thank you :)
That's great to hear Lee.
Awesome Leila thank you!
My pleasure. Glad you like the little trick :)
Hi, I use merge and centre. The text is then automatically adjusted to the cell. This also helps when wanting to copy and paste into other documents such as power point. Another useful feature is alt and enter. This shifts you down into another line within the same cell so you can have all your text grouped
WOW thanks LILI
This trick is simply great Leila.
I'm glad you like it Enrique.
Thanks for this tip. 😃
You're very welcome :)
That's a True Magic, Thanks for sharing
Glad you like it Faraz.
Great tip Leila!
I will use and share this tip on with my colleagues
Glad you like it Darren. Hope it will be useful for your colleagues.
Wow!! Really magic! I did a longer way to get this done. Thank you so much. I really appreciate
You're so welcome!
You are clips are very shorten and very easy to understand ... Hats off to you... 👏
Thanks for the kind words. I'm glad you like the videos.