Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

9. Type the desired macro description. 10. Select . 11. Perform the steps in the procedure you want to automate. 12. When you have finished recording macro steps, click

in the

Code group.



S TEP - BY -S TEP From the Student Data directory, open CITY57.XLSM . Record a macro.

If necessary, enable the macros.

Make sure that your current folder is set for the path containing the student data files.

Steps

Practice Data

1. Select the Developer tab on the Ribbon . The Developer tab is displayed. 2. Select the Record Macro button in the Code group. The Record Macro dialog box opens and the suggested text in the Macro name box is highlighted . 3. Type the desired macro name. The text appears in the Macro name box. 4. Select the Shortcut key box, if desired. The insertion point is placed in the Shortcut key box. 5. Type the desired shortcut key character. The character appears in the Shortcut key box. 6. Select the Store macro in list. A list of available options is displayed.

Click Developer

Click

Type Chicago

Press [Tab]

Type e

Click Store macro in

Page 30

OFFICEPRO, Inc.