Hidden Cells

[Guest]

Hi:

I have hidden rows and columns on my original worksheet.
I just want to copy and paste only the unhidden rows and
columns on to my new worksheet. When I try to copy and
paste special it copies all hidden and unhidden cells. Is
there a way to avoid to the hidden cells in my new spread
sheet?

Thanks

 

[Andy B]

Hi

Try Edit / Go to / Special / Visible cells. Then Copy and paste.