I am copying select cells from one workbook to another using Past Values
(using the toolbar button to paste). The value pastes, but if I hit enter
(rather than the down arrow), the value I just pasted reverts to the
formula/formatting of the cell I copied from. Is there an option I can access
to turn this off?

After pasting, hit "Esc" to let XL know you're done pasting. Or stop hitting
Enter.

The reason this is happening is that normally you can use Enter as a way of
Pasting and exit CopyPaste mode with a single keystroke. So, in essence,
you're currently telling XL to do a Paste Special - Values, and then Paste
all & exit CopyPaste mode.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Smeds128" wrote:

I am copying select cells from one workbook to another using Past Values
(using the toolbar button to paste). The value pastes, but if I hit enter
(rather than the down arrow), the value I just pasted reverts to the
formula/formatting of the cell I copied from. Is there an option I can access
to turn this off?