The last name stroke in WPS Excel can be sorted by Data-Sort in the toolbar.
In WPS Excel, the steps to sort by last name strokes are as follows:
1.Open WPS Excel and select the column you want to sort, such as the Name column.
2.Tap on the "Data" option in the menu bar and then tap on the "Sort" feature.
3.In the sort dialog box that appears, select Custom sorting.
4.In the Custom Sort dialog box, select Sort by currently selected area, and then click the Sort button.
5.In the Sort dialog box, click the Options button.
6.In the Sort Options dialog box, select the Sort Stroke option.
7.Click the "OK" button to sort by the number of strokes of the last name.
Notes:1Surnames with the same number of strokes are listed in the order in which they are started.
2.If the first character of the surname is the same, it is sorted by the number of strokes of the second character, and so on.
3.Make sure that all names have been entered correctly before sorting and that there are no spaces or other non-literal characters.
4.If you need to sort by multiple criteria, you can add multiple sort criteria in the Sort dialog box.
5.Before sorting, you'd better back up the original data to avoid unexpected situations that lead to data loss.
The above methods are for reference only, and the specific operation may vary depending on the software version or system environment. Alternatively, users can search the web for relevant WPS Excel tutorials or ** to learn more about the detailed steps and precautions for sequencing last name strokes.
Demo environment. Hardware model: Huawei MateBook D 15
Software version: Windows 10, WPS 365
App version: None.