Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

NOTE Shortcut keys are assigned as you are recording a macro by entering the desired shortcut key in the Record Macro dialog box. To use the Developer tab, you should ensure that the Show Developer in the Ribbon option is selected. This option is located in the Popular page of the Excel Options dialog box. Avoid assigning macro shortcut keys that are the same as the standard Excel shortcuts such as [Ctrl+O] and [Ctrl+S] . The macro shortcut key will override any equivalent Excel shortcut key while the workbook containing the macro is open.



P ROCEDURES

1. Select in the Code group on the Developer tab. 2. Select the macro to which you want to assign a shortcut key from the Macro list.

3. Select . 4. Type the desired shortcut key character. 5. Select . 6. Select .



S TEP - BY -S TEP Assign a shortcut key to a macro.

If necessary, enable the macros and display the Developer tab.

The macro used in the following steps does not contain a file path. As a result, it will look in the folder that contains the CITY57.XLSM data file. Make sure that your current folder is set for the path containing the student data files.

OFFICEPRO, Inc.

Page 33