Copying data

Hi Sharone

Thank you for your question

The easiest solution seems to be to select the cells either side of the hidden column/row when holding down the control key.

This selects non contigous ranges, whereas if you simply select "across" the hidden cells then the hidden element will also be selected and copied across, even though it will remain hidden.

Regards

Stephen