Now we get to one of my most favorite Excel hidden features.
I call it hidden because I don't see a lot of turorials on this and I didn't know it existed
for the longest time. When I found out about this feature, I was super happy because it was gonna save
me so much time going forward.
But I was also kind of mad because I'd have wasted so much time. And the best part is this feature is
sitting right there on the Home tab.
I just never knew what it did.
So in most of the Excel workbooks I create, I add an instruction tab or a control tab.
These tabs generally have a lot of text and I like to format them in a more readable way.
So for example if I have something that is this long and I've written instructions here, I want it to
be kept to this column.
So anything after should flow down.
So here's what I used to do.
I will go here, check out which word comes to let's say Column F, so everything after become.
I'm gonna highlight press Control+X, press enter,
go to the next line, Control+V. Then anything just after
this A,
So this part I will cut out, press enter,
go down, Control+V. And then I would remember to add a sentence here
because I didn't clarify something and then I'm gonna repeat all this over again.
But guess what.
There is an Excel feature that does this for you.
So let's just go back.
All you have to do is highlight the range you want your text to flow to.
In my case this is Column F and a few cells on the bottom here. Then go to Home, go to Fill, and click
on Justify. It did it for you.
It actually put the text in the next cell down below and then it cut that part and put it down below
here.
Now, you come to realize OK, you have to add some stuff or you actually wanted to just go to Column D.
You just need to highlight, go to Fill, and click on Justify.
Then you get a message that the text is gonna extend below the range because it's going to go down here.
That's fine.
Click on OK, check this out.
Now even if you wanted to reverse this and put back everything in the first line, all you have to do
is highlight. Just highlight a range that you think is going to fit all this text in the first line then
go back to fill, justify, and everything is back.
That's some hidden Excel magic.