Hi All

I have a spreadsheet where I have hidden a large number of rows which I want to remain hidden.

From the information I have left I want to copy this onto another worksheet without it carrying over the hidden cells.

I'm sure there must be a way but no matter what I try it copies the hidden rows also.

I'd appreciate anybody's help on this. :confused:

Howdy. Try this. Press CTRL + G (or on the menu Edit > Go To), then click on "Special" in the lower left corner. In resulting dialog box, on the right side select "Visible cells only". Click OK. That will select them, then hit CTRL + C to copy, and it should work for you.

Many thanks its worked a treat.

Cheers