How Excel tables are sorted by name

learning how to bring you the Excel table is sorted by name.

Excel sorts the steps by gestures as follows:

1, with Excel2013 Open an Excel file, example is a class list. You can see that the name bar is sorted randomly.

2, then, to start sorting. Select the entire table area, select "Data" in the menu bar, and select "Sort"

3, in the pop-up Sort window, in the main keyword, select "Student name."

4, then click "Options", pay attention to the selection according to "stroke sort", and then click OK.

5, at this time, the name has been sorted according to the surname strokes.