Copy and paste color

[Sophie]

I have a document that is protected and I have managed to put formulas on
certain cells with a background color. When my worker copies and pastes the
information into a new document since the cells she is copying are in color
they paste in color is there any way where when she copies and pastes she
only paste the numbers or data instead of the color of the cell?

Thanks,

-Sophie

 

[Steve]

Paste values only

 

[Sophie]

So is there a way that when I protect my sheet in excel I can set for the
worker to copy and automatically set for it to paste the values only or will
they have to do this?

 

[Gord Dibben]

Copy then Paste Special>Values


Gord Dibben MS Excel MVP