Excel Copying & Pasting with Filtered Lists

sharknado523

New Member
Joined
Jan 10, 2018
Messages
5
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.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,297
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top