1
00:00:01,040 --> 00:00:05,220
Now we get to one of my most favorite Excel hidden features.

2
00:00:05,270 --> 00:00:10,900
I call it hidden because I don't see a lot of turorials on this and I didn't know it existed

3
00:00:10,900 --> 00:00:17,000
for the longest time. When I found out about this feature, I was super happy because it was gonna save

4
00:00:17,000 --> 00:00:18,880
me so much time going forward.

5
00:00:18,980 --> 00:00:25,250
But I was also kind of mad because I'd have wasted so much time. And the best part is this feature is

6
00:00:25,250 --> 00:00:27,730
sitting right there on the Home tab.

7
00:00:27,860 --> 00:00:29,380
I just never knew what it did.

8
00:00:30,120 --> 00:00:35,470
So in most of the Excel workbooks I create, I add an instruction tab or a control tab.

9
00:00:35,600 --> 00:00:42,710
These tabs generally have a lot of text and I like to format them in a more readable way.

10
00:00:42,740 --> 00:00:48,770
So for example if I have something that is this long and I've written instructions here, I want it to

11
00:00:48,770 --> 00:00:51,050
be kept to this column.

12
00:00:51,110 --> 00:00:53,710
So anything after should flow down.

13
00:00:53,750 --> 00:00:55,630
So here's what I used to do.

14
00:00:55,730 --> 00:01:02,630
I will go here, check out which word comes to let's say Column F, so everything after become.

15
00:01:02,900 --> 00:01:06,260
I'm gonna highlight press Control+X, press enter,

16
00:01:06,260 --> 00:01:12,050
go to the next line, Control+V. Then anything just after

17
00:01:12,090 --> 00:01:12,650
this A,

18
00:01:12,740 --> 00:01:16,040
So this part I will cut out, press enter,

19
00:01:16,040 --> 00:01:20,920
go down, Control+V. And then I would remember to add a sentence here

20
00:01:20,930 --> 00:01:25,570
because I didn't clarify something and then I'm gonna repeat all this over again.

21
00:01:25,670 --> 00:01:26,460
But guess what.

22
00:01:26,460 --> 00:01:30,080
There is an Excel feature that does this for you.

23
00:01:30,080 --> 00:01:31,580
So let's just go back.

24
00:01:31,760 --> 00:01:37,630
All you have to do is highlight the range you want your text to flow to.

25
00:01:37,690 --> 00:01:46,190
In my case this is Column F and a few cells on the bottom here. Then go to Home, go to Fill, and click

26
00:01:46,190 --> 00:01:50,640
on Justify. It did it for you.

27
00:01:50,850 --> 00:01:57,970
It actually put the text in the next cell down below and then it cut that part and put it down below

28
00:01:57,970 --> 00:01:58,690
here.

29
00:01:58,720 --> 00:02:05,860
Now, you come to realize OK, you have to add some stuff or you actually wanted to just go to Column D.

30
00:02:05,860 --> 00:02:10,169
You just need to highlight, go to Fill, and click on Justify.

31
00:02:10,270 --> 00:02:15,010
Then you get a message that the text is gonna extend below the range because it's going to go down here.

32
00:02:15,010 --> 00:02:15,680
That's fine.

33
00:02:15,680 --> 00:02:17,750
Click on OK, check this out.

34
00:02:18,040 --> 00:02:23,830
Now even if you wanted to reverse this and put back everything in the first line, all you have to do

35
00:02:23,830 --> 00:02:30,760
is highlight. Just highlight a range that you think is going to fit all this text in the first line then

36
00:02:30,760 --> 00:02:34,770
go back to fill, justify, and everything is back.

37
00:02:35,080 --> 00:02:37,420
That's some hidden Excel magic.