Excel - How to Match Destination Format always

[Toadman]

It's called planned obsolescence and it bites big time. The next iteration of Word will probably only open in WordPad for pre-XP OS machines.

[CapK]

Quote:

Originally Posted by vass0922

doesn't seem to be possible
seems to be a new feature in Excel 2007
Set your own default Paste options with Word 2007 | Microsoft Office | TechRepublic.com

Infuriatingly, that only works in Word. In Excel the drop-down list isn't present.

[guesttttttbaby]

If you double click the cell you want to paste into then the destination formatting will be applied when you paste. Tested and verified.

[Jackulas]

The double-click option doesn't do exactly what the OP (or I) was hoping, but it does cut down on the tedium. Thanks so much.

[hutchinsfairy]

Not a complete solution but I recently used conditional formatting to force some format options to remain even when pasting.

Format --> Conditional Formatting...

Then Formula is: =$ZZ$10000=""

Set all the options you can (there aren't many) to what you want.

This will override any local formatting that you subsequently try to apply though...

[balfor]

Copy the data to the clipboard (CTRL-C) then, in Excel, double-click the cell (make sure you select all of the data if you want to replace it, then paste (CTRL-V). That worked for me.