How to copy cells without copying the hidden rows and columns?

T

tsewt23

I have hidden many rows and columns in an Excel document. I'm trying to copy
the remaining cells (viewable) into another Excel document. When I paste into
the new document, it has copied all the hidden cells as well.
 
F

Frank Kabel

Hi
- select your source range
- hit F5, click 'Special', choose 'Visible cells only'
- now copy+paste
 
Top