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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
No, but you can create a macro that pastes in that format and then make a
button for that macro.
 
Back
Top