theta
04-12-2012, 03:50 AM
Hi all...
I rarely do a straight Ctrl+C, Ctrl+V. I either paste values, or format...or both.
Is there any VBA addin (preferable as I can then turn it off) or code available so that I can create keyboard shortcuts for these 3 distinct scenarios. Maybe use some 'F' keys that aren't needed. Or...
Ctrl+Shift+? = Paste Value
Ctrl+Shift+? = Paste Formats
Ctrl+Shift+? = Paste All (Value + Format
I rarely do a straight Ctrl+C, Ctrl+V. I either paste values, or format...or both.
Is there any VBA addin (preferable as I can then turn it off) or code available so that I can create keyboard shortcuts for these 3 distinct scenarios. Maybe use some 'F' keys that aren't needed. Or...
Ctrl+Shift+? = Paste Value
Ctrl+Shift+? = Paste Formats
Ctrl+Shift+? = Paste All (Value + Format