Excel 2016 Macros

Lesson 1 - Using Macros

Excel 2016

E XERCISE

U SING M ACROS



T ASK Use macros in a workbook.

1. Open EXER81.XLSM and enable the macros. 2. Use the Macros button in the Macros group on the View tab to run the Sort_RegionSales macro. Notice that the macro sorts the data, first by region in ascending order, and then by annual sales in descending order. 3. Use the Macros button in the Code group on the Developer tab to run the Sort_LastName macro. Notice that the macro sorts the data by last name in ascending order. 4. Use the [Ctrl+r] shortcut key to run the Subtotals_Region macro. Notice that the macro adds an Outline and Subtotals to the sorted data. 5. Open the Visual Basic Editor window. 6. play the Module1 module in the Code window, if necessary. Scroll as necessary to view the Subtotals_Remove macro. 7. Close the Visual Basic Editor window. Then, run the Subtotals_Remove macro. 8. Hide the Developer tab. 9. Close the workbook without saving it.

Page 26

OFFICEPRO, Inc.