I was asked this question recently:
I answered:Can you tell me if there is a way to change my excel settings so that when I copy and paste, it pastes the value and not the formula. I know of a few ways, but if there is a way to make it my default (by only using ctrl C and ctrl V), it would save me a lot of time.
The only way to set paste special: values as the default, is to force a macro to do it on those key strokes. There is no other way to modify Excel to do this. An alternative is to do this is one of the following:
- Position you mouse pointer over the edge of the selected range and drag to the destination using the RIGHT mouse button. When you release the button, you can choose “Copy here as values only†from the context menu.
- Or; Select and CTRL+C to copy, then select destination and CTRL+ALT+V (to paste special). Press V (for values) and ENTER.
Is there another way; or if it has to be a macro, how will one create this to capture the keystrokes to use CTRL+V to paste as values only?
TX