Automatically generate corresponding data after selecting the excel drop-down menu.

1, which can be realized by using the filter function. First, open the excel table and enter the data to be filtered in the table.

2. Then click "Sort and Filter" in the toolbar of the start menu, and click "Filter" in the drop-down menu.

3. You can add a filter button in the title of the first row of data.

4. Click the filter button to the right of the name, select "Metal" in the open option summary, and then click OK.

5. Only the "metal" item will be displayed in the statistics, and all the corresponding data will be displayed.