Many friends are not yet familiar with the Excel software. During the operation, they will not copy and paste the filtered data. For this reason, the editor below will share a simple tutorial on copying and pasting the filtered data in Excel. I hope it will be helpful to you. oh.

Let's first demonstrate the wrong copy method. Take the following form as an example, screen, copy data, and stick the data into the second line of cells.

But after canceling the filtering, the data is not in the specified location.

​​​​​The correct operation is that the steps for copying are the same, except when pasting, instead of using CTRL+V to paste, select the location to be pasted first.

Finally, press the CTRL+R shortcut key to paste, and finally cancel the filter, and the data will appear at the specified location.

Here are a simple tutorial for copying the data after Excel screening. Friends in need should hurry up and read this article.