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

[John H @ EBR]

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

 

[Rayo K]

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