Home  >  Article  >  Topics  >  How to sort excel database

How to sort excel database

青灯夜游
青灯夜游Original
2020-08-28 11:41:2820185browse

For excel database, sorting is based on "field", and by default, sorting is based on the ASCII size of the first word of the data. How to sort excel data: 1. Select the area to be sorted, click [Data] menu → [Sort]; 2. Set [Main Keywords]; 3. Set secondary keywords, you can set multiple; 4. Click [OK] 】That’s it.

How to sort excel database

Excel database sorting is a relatively powerful function, which can instantly arrange messy data according to the size of the data.

Excel data sorting method:

Enter basic data in the worksheet, as shown below. The data is not sorted and is quite messy.

How to sort excel database

Select the area to be sorted and click [Data] menu → [Sort].

How to sort excel database

Click the button under [Main Keywords].

How to sort excel database

Select the main keyword, here, select [Production Line].

How to sort excel database

The main keywords are set successfully, click [Add Condition].

How to sort excel database

Set the secondary keyword, the method is the same as above, here it is [Product Type].

How to sort excel database

After clicking [OK], the data is sorted successfully.

How to sort excel database

Analysis of the above, the excel database is sorted according to the primary keywords and secondary keywords, and the secondary keywords include secondary keywords 1, 2, 3...These keywords are actually the title of the table!

How to sort excel database

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to sort excel database. 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