Forum Discussion
Paste TO visible cells only in a filtered cells only
Hello NSK-Mar
- copy the formula or value to the clipboard
- select the filtered column
- hit F5 or Ctrl+G to open the Go To dialog
- Click Special
- click "Visible cells only" and OK
- hit Ctrl+V to paste.
Muhammad_Asim I experience similar problem also when pasting into filtered cells. This seems like it should be pretty simple, but it doesn't work. See attached video evidence.
What is Microsoft's moderator response to this?
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!
