copy and paste only unhidden information

H

heatherB

i have an excel doc. that has hdden and unhidden information. i want to
copy and paste ONLY the unhidden information. When i copy and paste it it
takes everything hidden with it. how to i stop that from happening.?
 
D

David Hepner

You need to use the Select Visible Cells toolbar icon. Add this icon to your
tools bar. You can find it under the edit category of the customize toolbar
feature.

To use it selct your cells then click on the select visible cells icon and
hit copy.
 
Top