making one key shortcut for pasting values

12
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

Upload: kyungjpark

Post on 28-Nov-2014

1.365 views

Category:

Business


2 download

DESCRIPTION

How to make paste special -> values into Excel using Macro.

TRANSCRIPT

Page 1: 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

Page 2: Making one key shortcut for pasting values

SAMPLE EXCEL SHEET

Page 3: Making one key shortcut for pasting values

1. COPY FORMULA

Page 4: Making one key shortcut for pasting values

2. CLICK DEVELOPERS

Page 5: Making one key shortcut for pasting values

3. CLICK ANY BLANK CELL

Page 6: Making one key shortcut for pasting values

4. START RECORDING MACRO

Page 7: Making one key shortcut for pasting values

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+

Page 8: Making one key shortcut for pasting values

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

THE FORMULA IS STILL COPIED AND

THE CELL IS SELECTED

Page 9: Making one key shortcut for pasting values

7. STOP MACRO

Page 10: Making one key shortcut for pasting values

8. TESTING COPY FORMULA

Page 11: Making one key shortcut for pasting values

9. TESTING CLICK ANY CELL AND

“Ctrl + e”

10. TESTING SEE THE VALUE

Page 12: Making one key shortcut for pasting values

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

Selection.PasteSpecial Paste:=xlValues

ALTERNATIVE WAY