How do I copy & paste only the unhidden data on a worksheet ?

G

Guest

I'm sure this has a simple solution....I have a large worksheet that has a
lot of hidden rows. I want to copy and paste only the unhidden rows and can't
find a 'paste' function to do it.
 
P

Peo Sjoblom

Press F5. click special and select visible cells only, then copy and paste

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 

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
copy and paste only unhidden information 2
Pasting current view 1
Copying only unhidden rows 2
macro help 2
Excel- Saving only unhidden rows 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
showing hidden rows on a protected sheet 10

Top