All language subtitles for 2. Sorting Using a Custom List

So now we know how to sort on one column or multiple columns.

The final sort option I want to show you is how to sort using your own custom list.

Now what do we mean by sorting using a custom list?

Well, it might be that you have a data set that you want sorted in a very specific way.

One that is outside the boundaries of simply sorting A2Z or said to.

For example, if we take Column Ajuste just here, you can see that I basically have three items Miss

Mrs and Mr.

Now, if I want to sort this data set A2Z, I can write Glink go to salt and A2Z, and it's going to

put the messages at the top, the Mr's in the middle and the misses at the bottom.

If I right click and sort Zed to a, it's going to put the misses at the top, the Mr's in the middle

and the miss at the bottom.

Now in either of those two options, I don't get Mr.

At the top of my sort.

And what if I actually need them?

Maybe I need to sort this list by Mr. First, then miss, then Mrs.

Well, this is where we can use a custom salt.

Now, the first thing you would need to do here is basically write our type out your list in the salt

order that you prefer.

So in a blank cell somewhere over here, I'm going to write my salt order so I won't miss the first.

Then I won't miss.

I'm then I want Mrs.

And I can set this up as a custom list.

So to create a custom list, we need to go into file down to options and into our advanced settings.

Now, if we scroll all the way down to the bottom and it is quite a way down in the general section,

we can edit our custom lists and custom lists are basically those lists that when you typed the first

one in, you can then use your fill handler to drag down and complete the others.

And you might be more familiar with that when you're typing end dates or months of the year.

You can see that I also have some other custom lists that I've created in here as well.

So I'm going to set up my sort order as a custom list, and because I have them typed out in the cells

over here, I can choose to import them.

Now you don't have to import them from cells in a spreadsheet.

You could choose to create your own new list and simply type the entries in this box here, but we're

going to import them.

So let's just simply select the list and click import.

So there is my new custom list.

Let's click on OK.

And OK, again, so now I have those set up as a custom list, what I can do is use that custom list

as the sort order for my data.

So on the Home tab, let's go to sort of filter and into custom sort.

So now I'm going to salt by the title, I want to salt on the cell values.

But the older I want to use is determined by a custom list.

I can then just simply select my custom list.

Click on OK, click on OK again.

And it's supplied my very specific sort order.

Now, if I was to go and delete these entries from here, let's just delete those out.

It doesn't affect that sort order at all.