View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Can the default paste options on the clipboard be changed?

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

On Thu, 22 Oct 2009 10:43:02 -0700, Bobo
wrote:

When pasting copied cells which contain formulas is it possible to change the
clipboard default to paste values only?