copying and pasting

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting

Copying and pasting

resolvedResolved · High Priority · Version 2010

Eniola has attended:
Project Intermediate course

Copying and pasting

How do I copy and paste view only cells where some have been hidden?

without pasting the hidden cells and/or columns?

RE: 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

Fri 31 May 2013: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips


Server loaded in 0.11 secs.