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

How to set a default paste option of "Match Destination Format"
 

No, but you can create a macro that pastes in that format and then make a
button for that macro.

"John H @ EBR" wrote:

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