This topic will show you how to record a simple macro in Excel. Microsoft Excel has built-in Macro recorder that translate your actions into VBA macro commands.
- Click View Tab.
- Go to Macros Group.
- Click the dropdown symbol under Macro button.
- Click the Record Macro… in the sub list.
5. Click the Stop Recording button on the Ribbon or Status bar to stop recording.