I am working in Excel 2010 and noticing that when I Filter a Column of Data, when I copy any information down several rows, even the "Hidden Rows" are getting hit with the copied data.

The only way, I can find to get around this, is to copy and then hold down Cntrl Key and click on each individual row and do a Paste Special / Formulas, so that I can skip the Hidden rows. This is a huge waist of time and energy.....

Has anyone else encountered this?? Am I doing something wrong? Is there a way to stop this from happening?