4
2
Let's say I have some rows or columns that are hidden, and drag a selection across where those hidden values would normally be. Is there a way to prevent Microsoft Excel from copying those hidden cells?
I've found a workaround that sometimes works by pasting it all into Notepad, and then copying that, then pasting it into the spreadsheet I want to paste those values into, but it seems there should be a better way to do that. Unfortunately this workaround doesn't always work so well.
I believe that Select Visible Cells is (Alt)+
;
. – G-Man Says 'Reinstate Monica' – 2015-08-24T17:02:45.820@G-Man So your keyboard has a
;
key? I always have to pressShift
+,
:) – nixda – 2015-08-24T17:19:28.490Yes. – G-Man Says 'Reinstate Monica' – 2015-08-24T17:31:47.867
@G-Man Ok, then let's add the US version – nixda – 2015-08-24T17:36:35.547