| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Default Paste behavior
Is there any way to change the default bhavior of the paste operation so that
it pastes values only (without having to use Paste Special).? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Default Paste behavior
You could just have a macro and assign it a keyboard shortcut. I assigned z,
so if I hit CTRL+Z, it work work for me. My macros is: Sub PasteMacro() Selection.PasteSpecial Paste:=xlPasteValues End Sub -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "D Riggins" wrote: Is there any way to change the default bhavior of the paste operation so that it pastes values only (without having to use Paste Special).? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Up Default Behavior | Excel Discussion (Misc queries) | |||
| How do I change the default Paste behavior | Excel Discussion (Misc queries) | |||
| How do I change the default paste behavior | Excel Discussion (Misc queries) | |||
| Text Only Default Behavior? | Excel Discussion (Misc queries) | |||
| Changing default font for copy / paste | Excel Discussion (Misc queries) | |||
Linear Mode
