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.
Thanks that's very helpful. May I add that you need to copy (Ctrl + C) your selection after you select 'visible cells only'?