How to group the same content together in excel sheets?

How to group the same content together in Excel tables:

1. Open a table

2. Select the data in the name column. The selected mark is the thick black line in the table. Then, on the "Home" tab, select: "Edit" - "Sort and Filter" - "Custom Sort".

#3. At this time, the "Sort" window will pop up. Select "Name", "Sort By" and "Order" from the main keywords of the column. Just execute the default options.

#4. After clicking the "OK" option, return to the Excel interface again, and you will find that the same content in the name column has been arranged together.

5. The editor will explain the underlying reasons for sorting. Follow the same method as above to enter the "Sort" window again and click "Options" at the top. See Excel sorting rules.

#6. By default, after you select the corresponding data, it will be sorted. The direction is "sort by column". In the method The above is "alphabetical sorting". Under such rules, we can ensure that the same information in Excel will be arranged together.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to group the same content together in excel sheets?. For more information, please follow other related articles on the PHP Chinese website!