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.
I am not sure that works if you dont want to paste an ENTIRE column. There may be different content above or below which you dont want to overwrite, so your second bullet point "select the filtered column" does not work in that instance. Selecting just a cell results in "this action won't work on multiple selections".
Any other idea?