How to Record an Excel Macro

1. Open the Tools menu and select Macro, then select Record a Macro.
2. Fill in the blanks - the macro name, description, shortcut-key combination and worksheet where the macro will be available - in the Record Macro box that appears. The macro can be available from only one worksheet or from any worksheet.
3. Click on OK.
4. Notice that the word 'recording' appears in the lower left of the Excel screen while recording is in progress.
5. Perform a series of keystrokes or mouse actions. The macro will record them. You can record any normal Excel action.
6. Open the Tools menu and choose Stop Recording to complete the macro.
7. Activate the macro by pressing the shortcut keys you have selected or by selecting the macro from a list on the Tools menu. The macro will then reproduce the series of keystrokes you recorded.