Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

If necessary, enable the macros.

The macro used in the following steps opens the NEWYORK.XLSX workbook but does not contain a file path. As a result, it will look in the current folder for the file. If you opened the CITY56.XLSM file by selecting it from the recently used files list, the current folder may not be the folder that contains the NEWYORK.XLSX file. Make sure that your current folder is set for the path containing the student data files by using the Open command in the Office menu to open the CITY56.XLSM file.

Steps

Practice Data

1. Select the View tab in the Ribbon . The View tab is displayed. 2. Select the top part of the Macros button in the Macros group. The Macro dialog box opens. 3. Select the macro you want to run. The macro is selected. 4. Select Run . The Macro dialog box closes, and the macro runs.

Click View

Click

Click NewYork

Click

Close the NEWYORK.XLSX workbook.

U SING A S HORTCUT K EY  D ISCUSSION

Excel performs macro commands in sequence. If a macro has a shortcut key assigned to it, you can run the macro by pressing the shortcut key. A shortcut key consists of pressing the [Ctrl] key and a key assigned to the macro. If an uppercase letter has been assigned, you need to press the [Ctrl] key, the [Shift] key, and the letter assigned to the macro.

NOTE The workbook containing the macro must be open. Macro shortcut keys are case-sensitive. If the shortcut key is the [Ctrl] key plus the uppercase letter N , you must press [Ctrl+Shift+N] or the macro will not run.

Page 18

OFFICEPRO, Inc.