Excel Macro Tutorial

By Ted French, About.com Guide

Adding the Developer Tab in Excel 2010

1. Click on the File tab of the ribbon to open the file menu.


2. Click on Options in the menu to open the Excel Options dialog box.


3. Click on the Customize Ribbon option in the left hand window to view the available options in the right hand window of the dialog box.


4. Under the Main Tabs section of the options window check off the Developer option.


5. Click OK .


6. The Developer tab should now be visible in the ribbon in Excel 2010.

Adding the Developer Tab in Excel 2007

1. In Excel 2007, click on the Office button to open the drop down menu.
   
   
2. Click on the Excel Options button located at the bottom of the menu to open the Excel Options dialog box.
   
   
3. Click on the Popular option at the top of the left hand window of the open dialog box.
   
   
4. Click on the Show Developer Tab in the ribbon in the right hand window of the open dialog box.
   
   
5. Click OK.
   
   
6. The Developer tab should now be visible in the ribbon.

Previous

• Excel Macro Recorder Tutorial
• Adding the Developer Tab
• Adding a Worksheet Title / The Excel Macro Recorder
• The Macro Recorder Options
• Recording the Macro Steps
• Running the Macro
• Macro Errors / Editing a Macro

Next