When you’d like to sort with direction, you could not sort because Excel dose not have ‘Direction’ list. So in this article, I’d like to add ‘Direction’ into custom list. First, enter 16 direction from ‘North’ to ‘North-northwest’.
![Custom list of direction](http://fujiitoshiki.com/improvesociety/wp-content/uploads/Fig1_Direction-300x173.png)
Next, select ‘File’ tab, ‘option’ and ‘Advanced settings’. After scroll down, press ‘Edit custom lists…’ button.
![Edit custom list.](http://fujiitoshiki.com/improvesociety/wp-content/uploads/Fig2_CustomList1-300x216.png)
Click button on the right column of ‘Range of source list’.
![Press button to select range.](http://fujiitoshiki.com/improvesociety/wp-content/uploads/Fig3_CustomList2-300x183.png)
Drag to select the range you entered ago, press button. Cell range would be entered into the column. Press ‘Import’ button.
![Press "Import" button.](http://fujiitoshiki.com/improvesociety/wp-content/uploads/Fig4_CustomList3-300x183.png)
OK, ‘Direction’ list has been added to custom lists. Press ‘OK’ to close window.
![Custom list has been imported.](http://fujiitoshiki.com/improvesociety/wp-content/uploads/Fig5_ImportedCustomList-300x183.png)