How to Create a Macro in Excel 2010

1. Identify a complex series of commands you frequently give Microsoft Excel. For example, you could create a macro for formatting a group of cells with 8-point, blue Times New Roman font.
2. Choose the 'File' tab. Click 'Options' and 'Customize Ribbon.' Select the 'Developer' check box in the 'Main Tabs' list to easily access the macro creation tool.
3. Click 'Macro Security' on the 'Developer' tab. Enable macros under the 'Macro Settings' area.
4. Click 'Record Macro' to open a window and create a new macro in Excel.
5. Enter a unique name for your macro. Choose a name that begins with a letter, contains no spaces and accurately describes the macro's function.
6. Select an area to store the macro by changing the 'Store Macro In' field. Create a brief description of the macro so that you can remember its purpose later. Click OK to close the window and begin recording.
7. Perform the series of functions you want to record. Perform each mouse click, keystroke or other function in the proper order to ensure that the macro will work properly.
8. Click 'Stop Recording' when you have finished your series of commands. Microsoft Excel automatically saves the macro when you click this button.
9. Test the macro by selecting an area upon which you want the macro to operate. Select the macro and press 'Run.' Ensure that the macro performs its function correctly.