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

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to set "match destination format" as default in paste? 1
paste options - set default to match destination formatting 1
How do I set the default paste option to "Match Destination Format 1
Make "Match Destination Format" the default 3
Paste in "match destination format" macro code 3
Automatically match destination formatting? 3
Paste - match destination 2
Excel 2007 Problem Paste/Enter Key 0

Top