Using Excel 2007 and found response below from 2005 but don't understand it.

Is there easier way in 2007? If so, can you explain in "laymen's" terms.
Don't know anything about macros.
thanks.

I cannot find a way to make Excel paste automatically using destination
formatting. A workaround is to use a macro to do the paste:

Sub PasteWithDestinationFormatting()
ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
False, NoHTMLFormatting:=True
End Sub

You could assign this to a shortcut key (Ctrl-Shift-v in this example) by
running this macro:

Sub SetPasteShortcut()
Application.OnKey "^V", "PasteWithDestinationFormatting"
End Sub


--
Jim
"Nuttysmallbar" wrote in message
...
|I have a spreadsheet where I would like everything I paste into to it to
| match the formattting of the cells around it--not retain the formatting it
| had in its original location. I don't want to have to select "match
| destination formatting" every time--I want it to default to that. Any
ideas?
| Thanks.