Copy and Paste in filtered range

When you work on a filtered range, you may be surprised by certain behaviors. By design, most of the actions you perform on a filtered range apply to visible cells only, which is good.

However if you had tried Copy and Paste in a filtered range, you could be frustrated because it did not paste in a way you expect. Indeed, it gives you totally unexpected result.

In this short video, I will show you what it is and a workaround to tackle that.

I hope you like it. If you do, please give a thumb up and SUBSCRIBE. 😉

Blogpost:
where you may download a sample file to follow along

#Excel
#CopyAndPaste
#Filter

[Fuhnance]

This is the best way to do this that I've found, and I looked everywhere.

[jessicamariaramoscardenas]

Hello, I have some data from other non filtered excel, and I want to paste into a sheet that is filtered, how can I do that?