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 » Copy in a filtered speadsheet
Copy in a filtered speadsheet
Resolved · Low Priority · Version 2003
Mon 28 Jul 2008, 16:28Delegate Sophie said...
Sophie has attended:
Excel Intermediate course
Copy in a filtered speadsheet
how to copy info in a spreadsheet that has hidden rows with the info copying only on the visible rows
Wed 30 Jul 2008, 14:36Trainer Simon said...
RE: copy in a filtered speadsheet
Hi Sophie,
Thank you for your question.
I have been looking at ways of trying to copy and paste data onto the visible results of a filtered list and I am sorry to say I have drawn a blank. I will pass this one around some colleagues to see if they have any suggestions.
Regards
Simon
Thu 31 Jul 2008, 12:31Delegate Sophie said...
RE: copy in a filtered speadsheet
Thank you very much, that would be great.
Tue 5 Aug 2008, 17:38Trainer Amanda said...
RE: copy in a filtered speadsheet
Hello Sophie
If you use the advanced filter feature (Data - Filter - Advanced filter) you then have the option of copying the results of the filter to a different location (away from the whole list of data you have), this way you get a copy of the filter results without it affecting your list.
I hope this helps.
Amanda
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:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
