98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pasting values and not hidden rows/columns | Excel forum
Pasting values and not hidden rows/columns | Excel forum
Resolved · Low Priority · Version 2007
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
Fri 11 Nov 2011, 10:48Trainer Andrew said...
RE: pasting values and not hidden rows/columns
Hi Julie
I saw this question posted earlier - for completeness I have added the answer here as well - let me know how you get on.
Kind regards,
Andrew
-----
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.
Thu 17 Nov 2011: Automatically marked as resolved.
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. |
Excel tip:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |
