Can the default paste options on the clipboard be changed?

  • Thread starter Thread starter Bobo
  • Start date Start date
B

Bobo

When pasting copied cells which contain formulas is it possible to change the
clipboard default to paste values only?
 
Not the clipboard, but you can drag the "Paste Values" Icon to a Toolbar.

Copy your range.

Select a pasting cell then hit the Paste Values Icon.


Gord Dibben MS Excel MVP
 

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

copying a formula 1
Excel 2010 not allowing me to paste as formula 5
How to copy/paste without using clipboard? 11
how to copy, do something else, THEN paste? 1
Copy/Past from Word-spreadsheet format alignment disregarded 3
Cannot copy worksheet to another file 2
"Cannot Empty the Clipboard" in Excel 2007 1
paste option disabled after clicking copy 5

Back
Top