Macros are a very useful tool in Microsoft Excel. If you have a spreadsheet in which you perform the same set of functions repeatedly, a macro is the perfect way to consolidate several tasks into one simple mouse click. A macro will record any sequence of commands. You can then save the macro and play it back at any time to perform that same sequence. This is useful when the information changes frequently, but you routinely need to run the same calculations on it, or if you want to quickly format a cell with a specific size, font and colors all in one action.
Instructions
Building a Macro
1. Select the cell in which you will begin your commands. Before you begin you should have an idea of several actions that need to be performed in a specific sequence for your macro.
2. Go to "Tools," "'Macro," and select "Create New Macro."
3. Choose a name and shortcut for your macro. This will determine how you find and use it. Selecting a shortcut key can make using your macro even easier. Note that if you enter "A" as your shortcut key you will need to press Ctrl+Shift+A to activate the macro, whereas entering "A" will require you to press only Ctrl+A.
4. Begin recording your macro. Every action you take will now be recorded as part of your macro. You may want your macro to format cells a certain way, copy and paste or perform calculations. Perform these actions carefully and in the correct sequence.
5. Stop recording. When you are finished, click the stop button in the macro window.
Running Your Macro
6. Select the cell on which you want to run your macro.
7. Click on the "Tools: menu, then select "Macro" and "Macros."
8. Select the name of your macro from the drop down list, and click "Run."
Tags: your macro, your macro, cell which, Macro Select, Macro Select cell, Select cell