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!