Use Microsoft ® Excel ® to: 2007, 2010 and 2013.
Step 1: Lets take the below example . Highlight the range C3:C5, as follows:
Step 3: And then import the list by clicking import and OK .
Step 4: Import items from the range C3:C5 in the spreadsheet, you can also type a custom list by entering a subject list and click Add.After click the import are listed as follows:
Step 5: Click OK twice to sort by a custom list. Click on the Data tab , and then arrange .
Step 6: Select the name of the category and the custom list is as follows:
Step 7: And then select the custom lists that show Priority and then click OK. .