Forum Discussion
Paste TO visible cells only in a filtered cells only
Hi Russell. I'm facing the same issue. It copies over the hidden rows, but gives the same error when I try to paste it
How can it be possible that the world`s leading company in terms of office software is not able to offer a simple way to solve such a problem. It's one of their basic business models and they just fail to do a good job. And there are a lot of similar problems beside the mentioned one. I can go through thousands of values of my thesis now to check whether something according to that issue went wrong before. Thank you Microsoft for NOTHING!
jojo_die900 I agree. The whole point of having a filter is that you only want to work with those cells not hidden ones. I think the default behaviour should be: If you have 10 cells in the filter then paste in the same single source value if one source value selected and if you have 10 source values then paste the 10 source values into the 10 filtered values.
