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

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.

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

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


"Johnson748r" wrote in message
...
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.