Record Macro Excel. In the record macro dialog box enter a name. In the code group click on the macro button.
When a macro is recorded it can be used again by assigning a keyboard shortcut or from the view macro function. In the record macro dialog enter the following. To tie your macro to a keyboard shortcut type a letter.
However it isn t enabled by default.
Formatting selected cells etc. For example you can record a macro where you first update a table in excel and then open. Recording a macro is how you tell excel which steps to take when you run the macro. This is especially useful if you want to automate mundane excel tasks e g.
