Excel Macro Recorder
You don’t need to know how to code VBA in order to make macros that does basic tasks. There is a handy tool named Excel Macro Recorder. You can record your actions as a macro and have Excel repeat them whenever you like.
Macro recording is a very easy process. All you need to do is to click on Record Macro button which is located in Developer Tab and perform the actions you want recorded. When finished, click on Stop Recording button. And you have your macro ready for use.
You can also reach same buttons from status bar:
Now lets record our first macro. Our first macro will make change the formatting of the cell we select.
Click on Record Macro button. Excel will display Record Macro dialouge box and ask for a name. Name your macro and hit ok button.
Click any cell and perform these actions:
- Make text formatting bold.
- Make font italic.
- Change background color as red.
Stop recording after you finished. Insert a button and assign your macro to this button (how to).
Now you can change multiple formatting options of a cell with one click. Click any cell then click on your button to see it working (try unempty cells for better observation).
Congratulations, you made your first macro with Excel Macro Recorder.