F5, go to special cells and select "Visible Cells". That will only select
what's visible, not what's hidden.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Churley" wrote:

I am trying to copy and paste filtered data from one column to an adjacent
column, but Excel copies the data in the hidden cells as well as the visible
cells. Short of copying one cell at a time, Is there a way to copy an entire
column of the visible cells only?

Thank you for your help