Copy/Paste Visible cells only

A

Ashley

How do I copy and paste visible cells only (don't want to copy the hidden
rows)?

Thanks.
 
G

Gord Dibben

F5>Special>Visible cells only>OK

Copy and paste to wherever.


Gord Dibben MS Excel MVP
 
Top