Paste - Match Destination Formatting

[philobr]

Is there a way in Excel to have the default paste set up as Match Destination Formatting by default.

I have lots of different sheets that I have to paste data into every day.
and they are formatted differently from the source.
Its a pain to keep choosing Match Destination Formatting every time.

Thanks.

 

[Andrew Poulsom]

You could try Paste Special|Values.

 

[philobr]

Yep that works, but I was thinking more of setting it as a straight Copy/Paste, rather than an extra step. Me just being lazy.
Cheers.