1. Select the data in the name column, and the selected mark is the thick black line in the table. Then, on the Start tab, select Edit-Sorting and Filtering-User-Defined Sorting.

2. How does 2.excel arrange the same name or the same information together?

3. The sorting window will pop up, and you can select the name, sorting basis and order from the main keywords in the column to execute the default options.

4. How does 4.excel arrange the same name or the same information together?

5. Click the "OK" option and return to the Excel interface again. You will find that the same information in the name column has been arranged together.

6. How does 6.excel put the same name or the same information together?

7. Let me explain the deep-seated reasons for sorting. Enter the "Sorting" window again according to the above method, and click "Options" at the top to see the sorting rules of Excel.

8. How does 8.excel arrange the same name or the same information together?

9. By default, after you select the corresponding data, it will be sorted, with the direction of "sorting by column" and the method of "sorting by letter". Under such rules, it can be guaranteed that the same information in Excel will be arranged together.