Quote Originally Posted by Steve Bryant
I want to recommend that you use the percentage blend rather than always going at 100%.
Dirk,
Blending is not applied when pasting data from the clipboard.
Blending is only applied when manually editing data using the F7/F8, Ctrl+F7/Ctrl+F8 and the Ctrl+= and Ctrl+- keys.

Regardless, I do not believe blending would help in your situation. Blending only applies to the cells just outside the border of the changed data, not the data itself.
Smoothing applied to the cells that received the pasted data, as explained by Steve, will smooth out the peaks and valleys.

Steve,
You post may be a little confusing, smoothing and blending are two distinct processes.
Smoothing is applied "after the fact" to existing data.
Blending is applied only when data cells are being changed by the user via the keyboard.

Regards
Paul