The QUICKEST & EASIEST Way to Work with TEXT in Excel (Fill Justify)

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.

🔑 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.

🚩Let’s connect on social:

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

[ec]

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

[dontown]

Been using Excel since 1993(Ver.5) & never knew about this. Thanks!

[SolomonKinyanjui_sk]

Anyone who has worked with excel may occasionally come across long sentences so this idea is wonderful I like it . Thanks Leila.

[CATRTT]

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.

[MrKallemyran]

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! ;)

[KnuYorker]

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.

[alexdickey]

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.

[sachinrv]

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 :

[congtrinh]

Thank you! I have been looking for this for so long.

[luisneto]

So simple... So useful!
Thanks Sheila.

[ngassthy]

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.

[markanthony]

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.

[vida]

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.

[excelisfun]

Totally agree - it is one of the best tricks in Excel for Text: Alt, E, I, J

[johanvanrensburg]

Thanks for all your educational video tips and tricks

[A]

Looked for this for so long. thank you!

[rksudera]

Concise & To The Point As Always... ❤

[summersandrew]

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

[alialbayati]

This is a time saver tip. Thanks for sharing. Looking forward for more tips.

[irviantantohadiprasetyo]

Wooowww....it's great and very helpful. Thank you Leila's. I love this channel.