Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pasting values and not hidden rows/columns
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pasting values and not hidden rows/columns
Resolved · Low Priority · Version 2007
Reply Tue 8 Nov 2011, 12:56Delegate Julie said...
Julie has attended:
Excel Intermediate course
Pasting values and not hidden rows/columns
when pasting values into a new spreadsheet how can I make it not paste hidden rows
For upcoming training course dates see: Pricing & availability
RE: pasting values and not hidden rows/columns
Hi Julie
Thank you for your question - give this a try and see if it produces the results you are looking for.
First highlight your data
On the Home Ribbon click Find and Select
(it's in the Editing group - you could always right click on it and add it to the Quick Access Toolbar if this is something you will be doing a lot)
Click Go to and choose Special
Click on Visible cells only and then OK
Now copy your selection (Ctrl + C)
When you paste your data into a new sheet you will find it only includes visible items.
I hope this helps - let me know how you get on.
Kind regards,
Andrew
Thu 17 Nov 2011: Automatically marked as resolved.
|