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!