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:12Trainer Andrew said...
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
