How to categorize different content in excel

How to classify different content in excel: First select the data in the worksheet, select [Sort] in the [Data] tab; then set the [Main Keyword] to [Department], and the order [Ascending Order] ]; Finally, click [Data] and [Classification and Summary] in sequence.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to classify different content in excel:

Step 1: Open a salary table, select the data in the worksheet, and do not select the title. [Sort] in the [Data] tab.

Step 2: In the sorting dialog box, set the [Main Keyword] to [Department], the order [Ascending Order], the ascending order is from small to large, the descending order is from large to Xiao, Chinese characters are arranged according to the first letter of Pinyin, A---Z is in ascending order, Z--A is in descending order.

Step 3: After the sorting is completed, you can summarize, [Data]-[Classification Summary].

Step 4: In the pop-up dialog box, select (Department) in [Category Field], select sum here as the summary method, and [Summary Item] can be based on Choose according to your own needs.

#Step 5: After confirmation, each department will be summarized.

Step 6: If you only want to display the aggregated results, just click the number 2 in the upper left corner. This completes the summary item.

Related learning recommendations:excel tutorial

The above is the detailed content of How to categorize different content in excel. For more information, please follow other related articles on the PHP Chinese website!