How to Paste in Visible Cells Only
Excel tries to help users in all spheres of work on the spreadsheet, but some of the help it offers may not be wanted at the time. For instance, if you try to paste data into a visible cell (a filtered cell), excel will also paste the data into the hidden cells (filtered-out cells). Excel