1) Go to the developer tab in excel. If the developer tab is not present, go to the office button, click excel options at the bottom right, and then under "popular" check the box that says "show developer tab in the ribbon"
2) Set up a new excel sheet, and type two cells with random numbers to copy, then a formula in a third cell (quick tip: easily sum up a column by hitting “Ctrl + =”) 
3) Select the cell with the formula, and hit “Ctrl + C” to copy
4) In the developer tab, select "record macro"
5) Change the macro name to PasteValues. Choose your desired key combo...for me “Ctrl + Shift + V” and store macro in "personal macro workbook" and create a description if desired.6) Click OK and you begin recording your macro: Since we already hit "Ctrl + C" in step 3, select any other empty cell, go to the home tab, click the arrow under "paste" and select "paste values"
7) Go back to the developer tab and select “stop recording macro” 
8) Your macro is not quite perfect yet...it has recorded to always paste to that cell. To change this, click "macros" in the developer tab, and double click your macro "PERSONAL.XLSB!PasteValues". An error will appear and select "debug" from the options to open Visual Basic Editor. 9) Delete the line that says "select.cell"F5" but you will likely have a different cell than F5. Then click File > Close and Return.
Your macro should work perfectly now...try it out on a new formula: "Ctrl + C", select a different cell from when you recorded the macro, and then "Ctrl + Shift + V" to paste values 10) Finally, when you close excel, choose "yes" to save changes to PersonalWorkbook, otherwise you will have to go through this process again.
Posts
