Hidden Rows

[Sharon Hague]

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.

 

[shades]

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.
________
Toyota Tr Engine

 

[Sharon Hague]

Many thanks its worked a treat.

Cheers