Excel 2016 Macros

Lesson 2 - Recording Macros

Excel 2016

Steps

Practice Data

1. Select the Macros button in the Code group on the Developer tab. The Macro dialog box opens with the first macro name highlighted in the Macro name box.

Click

2. Select the macro to which you

Click Atlanta , if necessary

want to assign a shortcut key from the Macro list. The macro is selected.

3. Select the Options button.

Click

The Macro Options dialog box opens with the insertion point in the Shortcut key box.

4. Type the desired shortcut key character. The character appears in the Shortcut key box.

Type a

5. Select OK .

Click

The Macro Options dialog box closes and the shortcut key is assigned to the macro.

6. Select Cancel .

Click

The Macro dialog box closes.

Use the [Ctrl+a] shortcut key to run the Atlanta macro. Then, close the ATLANTA.XLSX workbook.

U SING R ELATIVE R EFERENCES  D ISCUSSION

Absolute and relative references refer to how a macro records cell locations. When you use absolute references while recording a macro, Excel records absolute, or exact, cell references. For example, if you enter the label Annual Sales Report in cell A4 while recording a macro with absolute references, that label will always appear in cell A4 whenever you run the macro, no matter which cell is selected on the worksheet.

When you use relative references while recording a macro, Excel records cell references relative to the active cell. For example, if you type the label Annual Sales Report in the cell to the left of the active cell while recording a macro with relative references, that label will always be entered

Page 34

OFFICEPRO, Inc.