Copy/Paste Visible cells only

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Paste to Visible Cells only 1
Is it possible paste to visible cells only? 2
Paste into visible cells 4
copying one column with hidden/filtered rows to another colum 2
copy rows and paste onto visible only 2
Paste Special Values 2
large file - copy and paste small group 2

Top