Copying Rows when hiding other rows

N

Neutron1871

Every time I hide rows in excel and go to copy the visible rows, the hidden
rows also get copied. How do I copy the visible rows without copying the
hidden rows?
 
K

Ken Wright

Select the data and do Edit / Go To / Special / Visible cells only, then do your
copy.
 
D

Don Guillett

manually have a look at f5 goto special visiblecells or in a macro
specialcells(xlcelltypevisible)
 
Top