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.?

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.

"heatherB" wrote:

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.?

Hi Heather,
Highlight the range to be copiedF5SpecialVisible cells only
HTH

"heatherB" wrote:

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.?