Create a custom sort list in Excel

00:00 Use your own custom sort order in Excel
00:12 A to Z and Z to A still gives incorrect order e.g. basic, standard, deluxe
00:44 Custom sort via the Data Sort buttons (custom list option)
01:11 Create a new custom list (remembered within Excel so across other workbooks as well)
01:38 Custom list in reverse sort order

Create your own sort order list in Excel for times when alphabetically won't work. Useful, for example, for product categories (basic, standard, deluxe) or if you have a particular sort order for your branch's and divisions.