Question: how to do abc order in excel?
Answer: Select the cell range you want to sort. ... 
Select the Data tab on the Ribbon, then click the Sort command. ... 
The Sort dialog box will appear. ... 
Decide the sorting order (either ascending or descending). ... 
Once you're satisfied with your selection, click OK. ... 
The cell range will be sorted by the selected column.