copy and paste only unhidden information

  • Thread starter Thread starter heatherB
  • Start date Start date
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.?
 
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
[newbie] copy unhidden cells 1
macro help 2
Excel- Saving only unhidden rows 2
hide columns/rows/cells on open 4

Back
Top