How can I copy and paste only on the unhiden cells?

P

Peo Sjoblom

Select the cells, press F5, select special and visible cells only, click OK,
then copy


--


Regards,


Peo Sjoblom
 
M

meili

thanks a lot. it works out. :)

Peo Sjoblom said:
Select the cells, press F5, select special and visible cells only, click OK,
then copy


--


Regards,


Peo Sjoblom
Click to expand...
 

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

How to paste this down? 3
Copy addition formula of non-consecutive horizontal cells 2
Paste options button disappears 0
Paste to excel from word - auto format problem 1
Pasting a cell into bookmarked table from excel vba 1
How to enter a macro that performs when a file is closed 12
Visio shape text disappears upon copy paste 1
Pasting a range to a single cell 0

Top