How to generate a new table from filtered content

How to generate a new table from the filtered content: first open the table; then select the content to be filtered, and click the data option on the toolbar; then find Advanced in the data option and click it; finally Enter the advanced filtering interface and check Copy filter results to other locations in the method.

#1. First open the table. For example, you need to filter out the passing and failing data in the table and generate a worksheet from them.

#2. Select the content to be filtered and click the data option above the toolbar.

#3. After clicking on the data fold, find Advanced in the data options and click on it.

#4. Enter the advanced filtering interface and check Copy the filtered results to other locations in the method.

#5. Select the filtered area in the list area.

#6. Select the set condition in the condition area.

#7. Then select a worksheet copied to this location and click OK, so that the filtered content can be automatically generated into a worksheet.

#8. Finally, click Save As on the generated worksheet.

The above is the detailed content of How to generate a new table from filtered content. For more information, please follow other related articles on the PHP Chinese website!