Home  >  Article  >  Topics  >  How to keep only the filtered content in excel

How to keep only the filtered content in excel

angryTom
angryTomOriginal
2019-07-25 11:33:1947100browse

How to keep only the filtered content in excel

If you want to learn more about excel filtering operations, you can click: Excel Tutorial

##1. Open excel. In the figure below, a filtering operation has been added to the data in column A.

How to keep only the filtered content in excel

2. Click the drop-down box on the right side of "Data" and select only "334455" in the pop-up page.

How to keep only the filtered content in excel

3. After clicking OK, only the filtered data will be displayed and these cells will be selected.

How to keep only the filtered content in excel

4. Click "Find and Select" on the toolbar and select "Targeting Criteria".

How to keep only the filtered content in excel

5. Select "Visible cells" in the pop-up dialog box and click OK.

How to keep only the filtered content in excel

#6. Copy the previously selected cells.

How to keep only the filtered content in excel

7. Paste in the new cell position, you can see that only the filtered data is pasted. At this time, these new Just save the data.

How to keep only the filtered content in excel

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn