How to Create a Macro in Excel 2007

1. Open Excel 2007 and click the 'Developer' tab at the top-right end of the window. Click the 'Record Macro' button at the top of the 'Code' heading.
2. Type a name for the new macro in the 'Name' text box, such as 'Adding Columns' or 'My New Macro.' Type a key in the 'Shortcut Key' text box if you want to map a shortcut to the new macro. Pressing the 'Ctrl' key and the key you specify will automatically run the new macro.
3. Type a brief description of what the macro is intended to accomplish in the 'Description' box if you think other users may potentially need your macro. Click 'OK' to begin recording the new macro.
4. Perform the specific operations you want recorded in the macro, such as adding together the values in columns, creating new rows or calculating the average of two cells.
5. Click 'Stop Recording' when you are done performing operations. Click the 'Macros' button when you need to run the macro. Click the macro's name and then choose 'Run.'