copy/paste with hidden rows don't want hidden parts to paste

R

robynne

I want to copy information in a column that has hidden rows and do not want
the hidden information to paste. Is there any way to copy only what is
showing?
 
J

JW

Highlight what you want to copy
Press Ctrl+G
Click the Special button
Select Visible Cells Only
Click OK
Now only the visible cells in your original selection are selected.
 
Top