Last week I was delivering Excel training to a large group. Part of the training covered how to create custom lists for sorting. If that’s not something you’re familiar with, look at this screenshot…

I want to sort this multi-column list by Store Location but not alphabetically. I want to sort based on the following order…Los Angeles, Seattle, Delaware, Boston, New York. This is where a custom list is needed

I was demonstrating how to create a custom list but I was doing it in Excel on Windows. Someone typed into the Zoom chat that they were using a Mac and couldn’t find the option I was talking about.

In Excel on Windows you can create a new custom list right from the Sort dialog box but not on the Mac. Although you can create a custom list in Excel on the Mac, it’s done from the Excel Preferences not the Sort dialog box.

So after I’d shown them how to do it on the Mac and after the training had ended, I thought “That’s probably a good topic for a quick video”…

You can download a copy of the file I used in the video by clicking through to YouTube. The link for the file is in the YouTube description.