Excel Macro Steps

Step1Open the Tools menu and select Macro, then select Record a Macro.Step2Fill 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.Step3Click on OK.Step4Notice that the word ..."recording" appears in the lower left of the Excel screen while recording is in progress.Step5Perform a series of keystrokes or mouse actions. The macro will record them. You can record any normal Excel action.Step6Open the Tools menu and choose Stop Recording to complete the macro.Step7Activate 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.