Microsoft Excel - Creating Custom Lists to Sort Data in a Specific Order

Have you ever needed to sort Excel data in a specific order other than alphabetical, Ascending/Descending? For example, if you have a list of clothing inventory and you want to sort the list by size. Alphabetical, Ascending sort would sort sizes with LARGE first, not X-SMALL.

DOWNLOAD THE EXERCISE FILE TO FOLLOW ALONG:

[theotisjames]

This is very different for Mac users for some reason. And not in the Excel Tabs.

This is the instruction for Mac:

On the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists .

Click Add.

Type the values for your list in the order that you want them sorted, with a comma between each value.

When you are finished, click Add, and then close the Custom Lists box.

[hasnine]

Very helpful within matter of a few minutes; Thanks Kyle :-)

[kevincappelli]

How can I personalize list entries on Mac? I don't have that "NEW LIST" button as well....

[blazer]

Keepem coming! You gonna make another python course (intermediate)?

[Danny-Do-It]

how do you turn this custom list into a sort macro?