View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John H @ EBR
 
Posts: n/a
Default How to set a default paste option of "Match Destination Format"

Does anyone know how to set the default paste option in Excel so that that
default is "Mathc Destination Formatting"? Quite often I copy data from one
document to another. I want the pasted information to match the format of
the destination document. Is there anyway so set a default so that I can
skip the step of having to specify match?
Thanks.
John H