copy cell content only
 

Hi,

I'm trying to copy cell content from a previous version of a worksheet to a
new updated version, but the copy/paste facility seems to copy the cell
formatting as well as the cell data across.

Is it possible to select cells and only copy the data contained within so as
not to alter the destination cell formatting? This applies to conditional
formatting and validation settings that I don't want overwritten.

Thanks,

Nick

copy cell content only
 

Hi Nick,

Try:

Edit | Copy
Edit | PasteSpecial | Values | OK


---
Regards,
Norman



"Nick Smith" wrote in message
...
Hi,

I'm trying to copy cell content from a previous version of a worksheet to
a
new updated version, but the copy/paste facility seems to copy the cell
formatting as well as the cell data across.

Is it possible to select cells and only copy the data contained within so
as
not to alter the destination cell formatting? This applies to conditional
formatting and validation settings that I don't want overwritten.

Thanks,

Nick

copy cell content only
 

Fab. Worked a treat. Thank you.

Nick

"Norman Jones" wrote:

Hi Nick,

Try:

Edit | Copy
Edit | PasteSpecial | Values | OK


---
Regards,
Norman



"Nick Smith" wrote in message
...
Hi,

I'm trying to copy cell content from a previous version of a worksheet to
a
new updated version, but the copy/paste facility seems to copy the cell
formatting as well as the cell data across.

Is it possible to select cells and only copy the data contained within so
as
not to alter the destination cell formatting? This applies to conditional
formatting and validation settings that I don't want overwritten.

Thanks,

Nick

copy cell content only
 

I've tried using PasteSpecial and choosing "Values" as mentioned below and it
*still seems to override the validation settings for the cells (by allowing
invalid data to be pasted). Or am I doing something wrong...?

Many thanks,
Ben

replyto:

"Nick Smith" wrote:

Hi,

I'm trying to copy cell content from a previous version of a worksheet to a
new updated version, but the copy/paste facility seems to copy the cell
formatting as well as the cell data across.

Is it possible to select cells and only copy the data contained within so as
not to alter the destination cell formatting? This applies to conditional
formatting and validation settings that I don't want overwritten.

Thanks,

Nick