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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I copy only the unhidden rows/colums? 2
Pasting current view 1
How do I copy & paste only the unhidden data on a worksheet ? 1
Copying only unhidden rows 2
macro help 2
[newbie] copy unhidden cells 1
Excel- Saving only unhidden rows 2
My rows keep "unhiding" when I do not want them to 6

Top