graphic2
graphic1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: Customize the Ribbon

pic1

Add the Macro to a Button

When we programmed the Macro we added a Shortcut Key. You can also run the Macro from the one of the Ribbons.

The quickest way to add a Macro to a button is with the Backstage Options. On the following pages, we will create a new Group on the Home Ribbon, then add the Macro to the Group.

 

2. Try it: Go to the Backstage

Go to File ->Options->Customize Ribbon.

Keep going...

File ->Options->Customize Ribbon