How to retain only the filtered data after filtering in excel

Excel implements the method of retaining only the filtered data after filtering: first open the Excel table; then click "Filter Data" to filter the data; then click the cell in the data with the mouse and press "Ctrl A" Select all the data; finally press "Ctrl+C" to copy the data and paste it into other cells.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Recommended: "Excel Tutorial"

The steps are as follows:

1. Open the Excel table on the computer.

#2. After opening the Excel table, click "Filter Data".

3. Filter data.

#4. After filtering out the data, click on the cells in the data with the mouse, and then press Ctrl+A to select all data.

#5. Select all data and enter Alt+; select only visible cells.

6. Select only the visualized cells, press Ctrl+C to copy the data, and then paste it into other cells.

The above is the detailed content of How to retain only the filtered data after filtering in excel. For more information, please follow other related articles on the PHP Chinese website!