Forum Discussion
Oghale
Feb 07, 2022Copper Contributor
Paste Special
How to paste in a filtered column skipping the hidden cells.
Feb 07, 2022
Hi Oghale
Copy the formula or value to the clipboard (Ctrl+C)
select the filtered column or Cells
Press Ctrl+G to open the Go To dialog box --> Click Special --> select "Visible cells only" --> OK
Press Ctrl+ V
This will help you copy just one value