Automatically match destination formatting?

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.

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" <Nuttysmallbar@discussions.microsoft.com> wrote in message
news:F777F54B-F578-47BD-B935-C0E23AA92038@microsoft.com...
|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.

I'll try that, thanks!

"Jim Rech" wrote:

> 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" <Nuttysmallbar@discussions.microsoft.com> wrote in message
> news:F777F54B-F578-47BD-B935-C0E23AA92038@microsoft.com...
> |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.
>
>
>