How do I quickly copy the filtered results of Excel?

1. Start Excel and open the workbook, and enter the filter criteria in two rows in the worksheet as the data source, as shown in Figure 1.

Ways to replicate the results of a filter directly in Excel

Figure 1 Input Filter criteria

2. Select the target worksheet and click the Advanced button in the Sort and filter group on the Data tab to open the Advanced Filter dialog box, select the Copy filter results to another location radio button as the filter result, click the Data Source button to the right of the list area text box, as shown in Figure 2. When the dialog box shrinks to include only the text box and the data Source button, the range of cells in the worksheet that is selected as the data source, the address of the range of cells is available in the text box, and the data Source button is clicked again, as shown in Figure 3.

Ways to replicate the results of a filter directly in Excel

Figure 2 How filter results are processed

Ways to replicate the results of a filter directly in Excel

Figure 3 Setting the list area

Tips

Select the show filter results in existing area radio button to display the filter results by hiding the data area that does not match the criteria, and select the copy the filter results to another location radio button to copy the eligible data to the specified location when you filter.

3, in the Advanced Filter dialog box, click the Data Source button to the right of the Criteria range text box, select the range of cells in which the condition is located, enter the address of the range of cells in the text box, and then click the Data Source button again, as shown in Figure 4.

Ways to replicate the results of a filter directly in Excel

Figure 4 Specifying the criteria area

4, at this time the Advanced Filter dialog box is restored to the original, click the Data Source button to the right of the Copy to text box, click the specified target cell in cell A1 on the current worksheet, and then click the Data Source button again to restore the Advanced Filter dialog box, as shown in Figure 5.

Ways to replicate the results of a filter directly in Excel

Figure 5 Specifies the target cell to which to copy

Tips

The list area text box is used to enter the address of a range of cells that you want to filter for data, and the range must contain column headings, otherwise it cannot be filtered; The Criteria range text box is used to specify a reference to the range where the filter condition is located, including one or more column headings and the matching criteria under the column headings; Copying to the text box specifies the range of cells where you want to place the filtered results, typically by simply entering the upper-left cell address of the range.

5, click the OK button in the Advanced Filter dialog box, and the filter results are copied directly to the specified worksheet, as shown in Figure 6.

Ways to replicate the results of a filter directly in Excel

Figure 6 Filter results copied to the specified location

Tips

You must first activate the target worksheet when copying, or Excel will pop up the prompt dialog box, and the copy filter will not succeed.