making one key shortcut for pasting values

Making one-key shortcut for Pasting Values (or other often used paste special)

Excel 2010

KJ Alternate way typing

alt+ctrl+v v enter alt+e s v enter

SAMPLE EXCEL SHEET

1. COPY FORMULA

2. CLICK DEVELOPERS

3. CLICK ANY BLANK CELL

4. START RECORDING MACRO

5. ENTER ANY NAME FOR MACRO. MAKE SURE YOU ADD “e”

J,E,M are the only free letters free from any shortcut keys with ctrl+

6. CLICK HOME & 123 (Paste Values) [NOTE] MAKE SURE

THE FORMULA IS STILL COPIED AND

THE CELL IS SELECTED

7. STOP MACRO

8. TESTING COPY FORMULA

9. TESTING CLICK ANY CELL AND

“Ctrl + e”

10. TESTING SEE THE VALUE

OR ALTERNATIVELY, IF YOU ALREADY KNOW HOW TO CODE MACRO, YOU CAN JUST CREATE ONE QUICKER

Selection.PasteSpecial Paste:=xlValues

ALTERNATIVE WAY

Business