Forum Discussion
Am I loosing my mind? Copy and Paste filtered cells
Hello Mich8261
I am sorry to say so but you did lose your mind 🙂
Excel can't possibly do what you want it to do the way you want it done. Excel thinks like this:
A) tell me what you want to copy? OK copy cells A2, A4, A6, A8, A10
B) Excel said OK You want me to copy 5 cells, got it.
C) Now tell me where you want me to paste these 5 cells.
D) You select cell B2.
E) Excel said OK cool so from B2 to B6 I will paste these 5 cells.
What would happen if you wanted to copy 5 cells from 5 different rows and 5 different columns?
You see the problem now?
I am not sure what settings allowed that I am very skeptical!Oh you can also check the Visible cells Only option under the Goto dialog and see if that may help in selecting cells that are filtered.
GAL.
Hello Mich8261
I am sorry to say so but you did lose your mind 🙂
Excel can't possibly do what you want it to do the way you want it done. Excel thinks like this:
A) tell me what you want to copy? OK copy cells A2, A4, A6, A8, A10
B) Excel said OK You want me to copy 5 cells, got it.
C) Now tell me where you want me to paste these 5 cells.
D) You select cell B2.
E) Excel said OK cool so from B2 to B6 I will paste these 5 cells.
What would happen if you wanted to copy 5 cells from 5 different rows and 5 different columns?
You see the problem now?
I am not sure what settings allowed that I am very skeptical!
Oh you can also check the Visible cells Only option under the Goto dialog and see if that may help in selecting cells that are filtered.
GAL.