1
00:00:01,430 --> 00:00:07,300
In this lecture we're going to take a look at another time saver that not so many people know of.

2
00:00:07,330 --> 00:00:08,140
Customs lists.

3
00:00:08,180 --> 00:00:14,360
Remember in a previous lecture, where we took a look at AutoFill. We looked at this example where I typed

4
00:00:14,360 --> 00:00:20,990
in January and then I pulled this down and I got the next month, the next month, and so on.

5
00:00:20,990 --> 00:00:22,520
Where is this coming from?

6
00:00:22,580 --> 00:00:29,990
It's actually coming from a custom list. The custom lists for days of the week and for months are already

7
00:00:29,990 --> 00:00:31,890
saved globally for you.

8
00:00:31,940 --> 00:00:35,770
The beauty of custom list is that you can create your own lists.

9
00:00:35,870 --> 00:00:42,560
So if you have specific regions that you keep using often in your Excel reports or specific products

10
00:00:42,590 --> 00:00:47,270
that you use often, you can keep them in custom lists.

11
00:00:47,360 --> 00:00:53,600
It doesn't just apply to this specific workbook but to your entire Excel application.

12
00:00:53,600 --> 00:00:56,840
Anything you save there you can use everywhere.

13
00:00:57,320 --> 00:01:06,550
Let's take a look at where they are. Go to File > Options, under advanced, scroll all the way to the bottom

14
00:01:06,890 --> 00:01:11,300
and you see custom lists here, click on edit custom lists.

15
00:01:11,300 --> 00:01:17,730
Notice here we see the Jan. Feb. example. We see January, February, Sun, Sunday, Monday.

16
00:01:18,020 --> 00:01:22,430
So these are the saved custom lists that came with Excel.

17
00:01:22,430 --> 00:01:29,630
Now let's create our own. I can type in all my regions here and then click on add or I can import them

18
00:01:29,930 --> 00:01:31,740
by just selecting these cells.

19
00:01:31,760 --> 00:01:37,850
So it's thinking that I want to import these. I'm just gonna get rid of that and highlight these.

20
00:01:37,850 --> 00:01:39,660
And then click on import.

21
00:01:39,740 --> 00:01:41,820
I can see them show up here.

22
00:01:41,880 --> 00:01:43,750
Now let's see how we can use this.

23
00:01:43,760 --> 00:01:52,120
So just click on OK and OK. If I go somewhere here and I start typing in North America.

24
00:01:52,130 --> 00:01:54,300
Now let's just drag this down.

25
00:01:54,500 --> 00:01:56,810
We see our entire custom list.

26
00:01:57,170 --> 00:02:00,130
And it's even recognize the case that I want them in.

27
00:02:00,140 --> 00:02:06,470
So I had originally given them these names but it's combined it somehow with Flash Fill and it realized that

28
00:02:06,470 --> 00:02:08,259
I want them in small letters.

29
00:02:08,330 --> 00:02:10,850
So let's keep the rest in the same way.

30
00:02:11,120 --> 00:02:13,340
Let's now open a new workbook.

31
00:02:13,340 --> 00:02:16,700
I'm going to press Control+n and that's a brand new workbook.

32
00:02:16,700 --> 00:02:17,830
It's called Book1.

33
00:02:17,880 --> 00:02:21,110
And right here let's type in North America

34
00:02:21,110 --> 00:02:25,700
and now let's drag this down and I have my custom list here as well.

35
00:02:26,340 --> 00:02:26,630
Okay.

36
00:02:26,660 --> 00:02:30,140
So that's the beauty of using custom lists in Excel.