Always Match Destination Formatting

Q: Following up on the tip Eliminate Unwanted Options in Word, is there a way during copy and paste to make "Match destination formatting" the default? I do a lot of copy and paste between Word to Excel, and each time, I have to check "Match destination formatting." It would be great if I could set this to happen as the default. - John Geyer. A: Word gives you detailed
control over this feature. Click the Office orb at top left, click the
Word Options button, and click Advanced in the list at left. In the
Cut, copy, and paste section there are four items that control the
default action when pasting text a) within a document, b) between
documents c) between documents with a style conflict, and d) from other
programs. Set the last one to "Match Destination formatting"; you may
also want to set the others the same way.
Excel doesn't have a similar setting, but there's a simple
workaround. If you press the Backspace or F2 key before pasting text it
will paste the text only, retaining the existing formatting. - Neil J.
Rubenking.