Excel 2016 Macros

Lesson 4 – Creating Macro Buttons

Excel 2016



S TEP - BY -S TEP

Format a macro button.

Steps

Practice Data

1. Select the Home tab in the Ribbon . The Home tab is displayed.

Click Home

2. To format all the button text, hold [Ctrl] and click the macro button you want to format. The mouse pointer changes into an arrow with a plus sign and the macro button is selected.

Hold [Ctrl] and click the Open Chicago button

3. Release the [Ctrl] key.

Release the [Ctrl] key

The mouse pointer returns to its normal shape.

4. Format the macro button text as desired. All the macro button text is formatted accordingly. 5. Select any cell in the worksheet to deselect the macro button. The macro button is deselected. 6. To format selected macro button text, hold [Ctrl] and click the macro button you want to format. The mouse pointer changes into an arrow with a plus sign and the macro button is selected.

Click in the Font group

Click anywhere in the worksheet

Hold [Ctrl] and click the Open Atlanta button

7. Release the [Ctrl] key.

Release the [Ctrl] key

The mouse pointer returns to its normal shape.

8. Select the text you want to format. The text is selected. 9. Format the selected text as desired. The text is formatted.

Double-click Atlanta

Click in the Font group

Page 66

OFFICEPRO, Inc.