Possible to set "match destination format" as default in paste?

[Guest]

I've recently been working a great deal in MS Excel and have been doing a lot
of moving data from another software tool and between workbook sheets.
Because of purposeful color coding of data in Excel, the new data being moved
is formatted incorrectly. I have the option of using the drop down menu on
the paste clipboard and clicking on "match destination formatting" or waiting
and using the format painter when the data is complete. It would be SO much
simpler if there were a way to set the default option in the paste clipboard
to "match destination formatting" instead of "keep source formatting" but I
have not found any option allowing me to do that! PLEASE help me! This is
making an already tedious process even longer!

 

[Pete_UK]

Instead of using <copy> then <paste>, you could use <copy>, move to
your destination cell then Edit | Paste Special | Values (check) then
OK and <Esc>. Pasting the values will not change the format of the
destination cell. I think you can actually add the Paste Special icon
to your toolbar, to make it even quicker.

Hope this helps.

Pete