Default Copy / Paste Mode

[Banta]

Hello,

A quick question from an excel fan who has searched everywhere but
can't figure something out:

There are two paste modes that I often use: Normal paste (CTRL-V) and
what I call "Destination Format Paste". The second I usually attain
either by a) right mouse click, paste special, then "paste values" or
b) normal copy paste, then click on the "paste options" pop-up icon,
then "Match Destination Formatting". Although I am aware that these
two approaches do slightly different things, basically they both serve
me to paste some data and just paste the raw numbers, not the source
formatting.

Here is my question: Is there a way to tell Excel to ALWAYS paste this
way? Is there a way to change the default copy & paste mode to be a
"just paste the numbers, not the format" copy & paste mode?


Thank you very much, I appreciate your time and help.

Manuel

 

[Don Guillett]

Goto your menu bar where the copy icon(often next to scirrors)>place cursor
next to it>right click>customize>commands>edit>look for the icon with the 12
on it>etc.

 

[linhqtran]

Is there a way a way I can turn that 12 icon into a keyboard short
cut?
(sorry for the noob question, having to reach for the mouse to select
the formatting is annoying)

Thanks

 

[Don Guillett]

I just recorded this
Sub Macro12()
'
' Macro12 Macro
' Macro recorded 11/27/2007 by Donald B. Guillett
'

'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

trim down to this and assign as desired

Sub Macro12()
Selection.PasteSpecial Paste:=xlPasteValues
End Sub