In this lecture we're going to take a look at another time saver that not so many people know of.
Customs lists.
Remember in a previous lecture, where we took a look at AutoFill. We looked at this example where I typed
in January and then I pulled this down and I got the next month, the next month, and so on.
Where is this coming from?
It's actually coming from a custom list. The custom lists for days of the week and for months are already
saved globally for you.
The beauty of custom list is that you can create your own lists.
So if you have specific regions that you keep using often in your Excel reports or specific products
that you use often, you can keep them in custom lists.
It doesn't just apply to this specific workbook but to your entire Excel application.
Anything you save there you can use everywhere.
Let's take a look at where they are. Go to File > Options, under advanced, scroll all the way to the bottom
and you see custom lists here, click on edit custom lists.
Notice here we see the Jan. Feb. example. We see January, February, Sun, Sunday, Monday.
So these are the saved custom lists that came with Excel.
Now let's create our own. I can type in all my regions here and then click on add or I can import them
by just selecting these cells.
So it's thinking that I want to import these. I'm just gonna get rid of that and highlight these.
And then click on import.
I can see them show up here.
Now let's see how we can use this.
So just click on OK and OK. If I go somewhere here and I start typing in North America.
Now let's just drag this down.
We see our entire custom list.
And it's even recognize the case that I want them in.
So I had originally given them these names but it's combined it somehow with Flash Fill and it realized that
I want them in small letters.
So let's keep the rest in the same way.
Let's now open a new workbook.
I'm going to press Control+n and that's a brand new workbook.
It's called Book1.
And right here let's type in North America
and now let's drag this down and I have my custom list here as well.
Okay.
So that's the beauty of using custom lists in Excel.