Copying and pasting

Hello Eniola,

Thank you for your question regarding copying and pasting visible cells only in Excel 2010.

1) Select the cells you wish to copy
2) From the Home ribbon click the Find & select button on the right side and then select Go To special
3) Select the Visible Cells only option and click OK
4) Copy
5) select the destination and Paste

Using the Visible Cells only option leaves out the hidden data.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer