How to Record an Excel Macro
A macro automates a complex task. Excel macros can perform complicated series of actions or simply record commonly used commands. These instructions apply to Excel 97.
Instructions
Step1 Open the Tools menu and select Macro, and then select Record a Macro.
Step2 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.
Step3 Click on OK
Step4 Notice that the word "recording" appears in the lower left of the Excel screen while recording is in progress.
Step5 Perform a series of keystrokes or mouse actions. The macro will record them. You can record any normal Excel action.
Step6 Open the Tools menu and choose Stop Recording to complete the macro.
Step7 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.
No comments:
Post a Comment