When you apply filters in Excel 2007, and then copy the filtered data from one sheet to another, you will find (to your frustration) that what has been copied to the new sheet is not just the filtered data, but also the invisible data that was filtered out. Oh, the ways of Microsoft! If I wanted to copy all the data, I would do it without using the filter. When I apply a filter, I am only interested in the resultant subset. And to think that this wasn’t a problem in previous versions of Excel baffles me even more.
Help is at hand, though. If you want to copy only the filtered result set, select it, then hit F5 to open the “Go To…” dialog. In this dialog box, click on the “Special…” button, and select the “Visible cells only” option. Now when you copy, only the visible cells are copied to the clipboard. And solves the problem!
Related posts:
- Copying Maps in JavaConsider this. You have a list* of maps. You want to replicate the list a specified number of times. For...
Tags: Excel 2007, workaround
Matty on 
April 21st, 2008 at 11:23 am
Oh.
Ok.
July 16th, 2008 at 10:18 am
Thank you for posting this workaround – I can’t believe MS bungled such an obvious and common action. I thought I was going crazy when I couldn’t get it to work like it has in 2003, 2000, 98…
December 31st, 2008 at 7:20 am
Even the paste special function is not reliable. In many of the cases, it does not work. Pl. help with some other advice.
September 4th, 2009 at 11:47 am
Phew!!.. Thanx a lot mate..