Excel Copying & Pasting with Filtered Lists

[sharknado523]

Hello everyone,

I am having a random issue with Excel. Usually, in order to copy visible cells only I'd have to use Alt + ;. Now, it seems to be doing this automatically.

Is this a setting I've inadvertently enabled, has Microsoft done an update, or am I just crazy?

Thank you.

 

[Dryver14]

I think you have always been able to just copy visible cells on autofilter, I think you still need to special select when using advanced filter