Not avoiding copy & paste in hidden / filtered cells

I think that you can add the Clear button to the QAT. Right click in the QAT and choose Customize. Choose All Commands, scroll down the list and right after Circular References is Clear. It has a Funnel with an X as an icon. Add to the QAT. Now when you want to clear the filters just click on that button and all filters will be cleared.

I just did a little experiment and found that after using Visible Cells Only and copying and pasting, the selection was still there even after resetting the filters. Hitting the Esc key "released" the selection and normal copying and pasting was again available. Even without resetting the filter, normal copy and paste returned after hitting the Esc key.

Ok, I see what you are referring to. Once you select "Visible Cells Only" that will apply to filtered data. When you re-apply a filter, and copy, you will get "Visible Cells Only". If no filter is applied, then Visible Cells Only is rather redundant because you are copying the visible cells. If you want to copy more than what is presented, don't apply a filter and manually select the area that you want to copy (no hidden cells). If you want to copy the cells that are hidden, why hide them? This is a "sticky" selection which is much like Custom Sorting. Once you create a custom sort for a data range, that sort stays with the data so that the sort doesn't have to be re-built the next time that you want to use it.