Forum Discussion
NSK-Mar
Nov 17, 2019Copper Contributor
Paste TO visible cells only in a filtered cells only
I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks
Nov 17, 2019
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.
Karthik_el_M10
Nov 20, 2019Copper Contributor
Is it possible to paste multiple values in the visible cells instead of same value or formula, can you please help me with this query.
I have also attached a file with an example, kindly assist.
This is the initial file with pivot.
getting this summarized as below.,
filtering on Messi, as Messi is the first person and hence filtering and have to accommodate the headers (Free kick, penalty & Dribble) to Messi and later I can paste it to rest of players.
Here I face the problem of pasting in visible cells in the filtered column, please assist me with the solution.
Thanks!
- Karthik
- RosemaryGithinji66Dec 24, 2023Copper Contributor
How do i paste multiple values on visible cells on a filtered array in excel?