Home  >  Article  >  Topics  >  How to categorize different content in excel

How to categorize different content in excel

coldplay.xixi
coldplay.xixiOriginal
2020-12-18 11:09:5219806browse

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.

How to categorize different content in excel

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.

How to categorize different content in excel

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.

How to categorize different content in excel

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

How to categorize different content in excel

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.

How to categorize different content in excel

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

How to categorize different content in excel

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.

How to categorize different content in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn