Make repetitive steps easier by automating them with a macro.

1. Select the cell in which you want to record the macro.
2. Click on the Developer Tab.
3. Click on Record New Macro.
4. Enter the name of the macro in the Macro name box. The name must be a single word with no spaces, and the first character must be a letter. You can use the underscore to separate words in the macro title.
5. Assign a keyboard shortcut, if desired. You can assign the macro to a toolbar icon later, if preferred. Note: If you use a keyboard shortcut already in use, i.e., Ctrl + P, you can overwrite the original shortcut.
6. Enter a description for the macro, if desired.
7. Make your selection in the Store macro in: box.
8. Click OK.
9. Click on the Relative reference button in the Code Group on Developer Tab, if desired.
10. Execute each keystroke and/or mouse click necessary to complete your macro.
11. Click on the Stop recording button on the Ribbon.
12. Excel records the macro and stores it in the workbook you selected.

Excel Macro Training Classes

Learn more about Macros in our Excel Advanced Training Class in Denver Colorado.

This entry was posted on Sunday, October 9th, 2011 at 11:36 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.