Tech Tip of the Week

Adding custom keyboard shortcut

To add a custom keyboard shortcut, add, save and store a VBA code line. The general custom keyboard shortcuts be saved in the Personal Macro Workbook. To create one, select Macro from Tools menu and then Record New Macro. In the Macro box insert a name for the macro. In the shortcut key box, press shift+V, choose personal Macro Workbook from the store macro in dropdown list and click OK. After recording, press the Stop recording icon. Open the VBE by pressing Alt+F11 and double click Module1 under VBA Project.

In the PasteValues macro, replace the lines recorded with: Selection.Formula=Selection.Value

This code converts a selected cell’s formula to its current value. Click Save, press Alt+F4 to close and then reopen Excel.

To determine if PERSONAL.XLS is open, select Unhide from the Windows menu. To check the keyboard shortcut, select cells containing formulas, and press Ctrl+Shift+V.