This quick video explains Sorting Data in Excel using a custom list. Excel provides a mechanism to sort using a custom list – this allows us to specify the preferred sort order for a list.

So instead of a simple alphabetic list going from A-Z or Z-A, we can use Excel’s built-in lists or create a custom list to sort in a preferred order – for example sorting regions North, South, East and West – not in the order East, North, South and West.