Paste Special

%3CLINGO-SUB%20id%3D%22lingo-sub-3134033%22%20slang%3D%22en-US%22%3EPaste%20Special%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3134033%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20paste%20in%20a%20filtered%20column%20skipping%20the%20hidden%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3134033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

 

How to paste in a filtered column skipping the hidden cells.

1 Reply

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