copy cell content only

[Nick Smith]

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

[Norman Jones]

Hi Nick,

Try:

Edit | Copy
Edit | PasteSpecial | Values | OK


---
Regards,
Norman



"Nick Smith" <NickSmith@discussions.microsoft.com> wrote in message
news:5AE24D20-E404-4354-A70D-7092D9FA02D6@microsoft.com...
> 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

[Nick Smith]

Fab. Worked a treat. Thank you.

Nick

"Norman Jones" wrote:

> Hi Nick,
>
> Try:
>
> Edit | Copy
> Edit | PasteSpecial | Values | OK
>
>
> ---
> Regards,
> Norman
>
>
>
> "Nick Smith" <NickSmith@discussions.microsoft.com> wrote in message
> news:5AE24D20-E404-4354-A70D-7092D9FA02D6@microsoft.com...
> > 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
>
>
>