Copy and paste color
 

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

Copy and paste color
 

Paste values only

"Sophie" wrote:

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

Copy and paste color
 

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?

"Steve" wrote:

Paste values only

"Sophie" wrote:

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

Copy and paste color
 

Copy then Paste SpecialValues


Gord Dibben MS Excel MVP

On Thu, 11 Feb 2010 13:27:02 -0800, Sophie
wrote:

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