Paste Special

  • Thread starter Thread starter Smeds128
  • Start date Start date
S

Smeds128

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Problem Paste/Enter Key 0
Paste Special Values 2
copy and paste 4
I can't copy and paste equations 0
Copy & Paste Special Operations 2
Cell changes to a formula after hitting ENTER 4
Paste Special Formula Multiply feature doesn't work anymore 2
problems getting this macro to work 23

Back
Top