How does Excel add a drop-down option?

How Excel adds a drop-down option

1, to add the Drop-down option in Excel, and use this function, we first find a piece of data, as shown in the following table, this is a data of the same measurement object, we add the Drop-down option to find the specified data.

2. These data are sorted by column, and the first line of each column fills in the title of the data. The main thing is to tell you what this line of data is, not just the numbers.

3. In fact, the "drop down" option in Excel is called "filtering" in a professional term. Select the row for the title, and then locate start-edit-sort and filter-filter, and click Filter to add a drop-down option.

4, this is added in Excel drop-down options, the flag is in the header row in each cell, in the lower right corner of the position is more than a drop-down triangle.

5. How do I use the Pull-down option? We click on the bottom of the triangle, will pop up a small window, which will display all the data of the column cell, if it is a number, according to the order of small to large, if it is Chinese or English, will be arranged in the order of the first letter. This makes it easy for us to find content quickly.

Warm tips

Because a table is a whole, and the filter function is for the entire table, in the same Excel table, the Drop-down option can only be used once, you will find that once you have used the filtering function, you can not use. If you click "Filter" again, the filter function is canceled.