Sort method: First select the cells that need to be operated, click "Start" - "Sort and Filter" at the top of the page; then select "Custom Sort" in the drop-down menu, and in the new window that pops up Select "Options"; finally click "Alphabetical Sort" in the "Method" option and click "OK".
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
First insert a table and select the worksheets that need to be sorted by first letter.
Then click Sort and Filter, then click Custom Sort.
Then a dialog box will pop up, click the options button.
#Another dialog box pops up, click Alphabetical Sort, click OK, and then click OK.
Finally you can see that the worksheets have been arranged according to the first letter.
Related learning recommendations:excel tutorial
The above is the detailed content of How to sort by first letter in excel. For more information, please follow other related articles on the PHP Chinese website!