Excel Macro Recorder Tutorial
Note: For help on these steps, refer to the image above.
Related article: Excel 2003 Macro Tutorial
This tutorial covers using the macro recorder to create a simple macro in Excel. The macro recorder works by recording all keystrokes and clicks of the mouse.
The macro created in this tutorial will apply a number of formatting options to a worksheet titles.
In Excel 2007, all macro - related commands are located on the Developer tab of the ribbon. Often, this tab needs to be added to the ribbon in order to access the macro commands.
The topics covered by this tutorial include:
- Adding the Developer Tab
- Starting the Excel macro recorder
- Excel macro recorder options
- Recording the macro
- Running the macro
- Macro errors / Editing the macro
