First, open a copy of Excel, and then according to your actual needs to see the custom number to add, small series below to "Research and Development Department, Ministry of Personnel, finance Department" as an example, now excel in the order of these text, then click on the menu bar "file" option, in the pop-up menu select "option";
Second, in the pop-up window select "Advanced", then the right side of the interface down, find "Edit the Custom list", click it;
Third, then in the Pop-up custom window, select the Import button, our custom text serial number import;
If you click No response, the custom sequence a column down, to the bottom can see our custom text sequence, click to select the right side of the "add", then select the bottom right corner of the "OK";
Return to the previous Advanced window, click OK again to return to the Excel table interface;
Select the area you want to sort, and then click "Data--sort" on the menu bar.
In the pop-up window, select the "key keyword" item you want to sort, and then select the order as "custom series";
In the pop-up window, select the custom sequence we identified before, click OK.