I want to paste a formula or value in the visible cells of a filtered column. How to go about it?

• 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.