How Do I Use The Alt+; Excel Shortcut To Select And Copy/Paste Only Visible Cells?
Say you have 1000 rows of data, with 15 hidden rows. You’ve hidden those 15 rows because you don’t want to copy them. You select the 1000 rows with Ctrl+A, then you do Ctrl+C to copy, and then Ctrl+V to paste. Your selection (before you paste) looks like this:
You’re moving fast and you think you’re a shortcut genius. But to your chagrin, they hidden cells get copied anyway.
Why? Because you selected them (even if you didn’t know it).
So how do you solve this problem without slowing down?
Simple: Alt+; [Read more…]