Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016

Steps

Practice Data

1. To move a macro button, hold [Ctrl] and click the macro button to select it. The mouse pointer changes into an arrow with a plus sign and the macro button is selected.

Hold [Ctrl] and click the Open Atlanta button

2. Release the [Ctrl] key.

Release the [Ctrl] key

The mouse pointer returns to its normal shape.

3. Point to the shaded border

Drag the Open Atlanta button below the Open New York button

around the button and drag the selected macro button to the desired location on the worksheet. The mouse pointer changes into a four-headed arrow and an outline of the button appears as you drag. 4. Release the mouse button. The button moves to the new location. 5. Select any cell in the worksheet to deselect the macro button. The macro button is deselected. 6. To size a macro button, hold [Ctrl] and click the macro button to select it. The mouse pointer changes into an arrow with a plus sign and the macro button is selected.

Release the mouse button

Click anywhere in the worksheet

Hold [Ctrl] and click the Open Chicago button

7. Release the [Ctrl] key.

Release the [Ctrl] key

The mouse pointer returns to its normal shape.

8. Drag any sizing handle in the desired direction.

Drag the top-center selection handle of the Open Chicago button to the top of row 3

The mouse pointer changes into a two-headed arrow and an outline appears as you drag.

9. Release the mouse button. The size of the macro button changes accordingly.

Release the mouse button

Page 68

OFFICEPRO, Inc.