Forum Discussion
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
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.
IngeborgHawighorst
I'm working on a time-sensitive deliverable for work and am running into the following and could really use your help asap - thanks!!!
Hi, I think I did instructions as explained but I get the message:
"The Action won't work on multiple selections."
Where I did it wrong?
I have an active filter
I copied the column I want to replicate "as is" into another column
I selected the "another column"
I did F5-Special-Multiple Only - OK
I pasted from where I am (the "another column")
but I get this error message.
Thanks.
I'm working on a time-sensitive deliverable for work and am running into the following and could really use your help asap - thanks!!!
Hi, I think I did instructions as explained but I get the message:
"The Action won't work on multiple selections."
Where I did it wrong?
I have an active filter
I copied the column I want to replicate "as is" into another column
I selected the "another column"
I did F5-Special-Multiple Only - OK
I pasted from where I am (the "another column")
but I get this error message.
Thanks.
