Ctrl+O, Opens the Open dialog box to locate or specify a file to open. If this keyboard assignment is unique to this document then you may wish to change the 'Save changes in' dropdown to your document name. Excel Shortcut Keys Ctrl+N, Create a new workbook. Under Store macro in, select Personal Macro Workbook. Bear in mind that you can override standard keyboard shortcuts here, so if you make your macro run with Ctrl + Z, you won't be able to use that shortcut to undo anymore.

If you don't mind overriding that default, click the 'Assign' button on the lower-left to assign 'Ctrl+f: to run your 'fred' macro.īy default the assignment is saved in the Normal.dotm document template. The shortcut box shows Ctrl + another key, but you can also add Shift to this by holding it while you select a key.

In this case it shows 'Currently assigned to NavPaneSearch'. Click the 'Press new shortcut key' textbox to make it active.

The Macros list box should now show the list of custom macros.

In the Categories listbox scroll down to the buttom and select Macros.

Click 'Keyboard shortcuts: Customize' button.Click on Customize Ribbon (from my perspective this is the non-intuitive step).The scenario is you created a macro named 'fred' and you want to execute the macro by typing Ctrl+f. Here is how to assign a keyboard shortcut to a custom macro in Word 2013.

Create shortcuts for excel 2016