How to Add and use Macro in Microsoft Office Excel or Worksheet
One of the most used package in Microsoft office Excel. Macros is an exrodinary feature included in Excel, It will be ver useful when you want yourself to do the same repeated task on different cells or on excel worksheets.
The Macros record the repetitive actions and do repeat the same actions in a single click.
Steps to create macros.
Open a New worksheet -> go to Tools -> Macros -> Record new macro.
There you will find the Record Macro dialogue box
Description of fields
- Name - Name of your macro.
- Shortcut key - (optional - shortcut key) this has to be a letter,
we have used S, so in our example the macro
will run every time we hold down the CTRL key and press the S key.
- Store macro in - This would normally be the workbook you are working on, but you
can save macros into a personal macro workbook.
- Description - Here you can enter a description of the macro for your benefit.
When you have finished filling in the information click the OK button to start the macro recorder.
- You will now see the macro recording box.
- Everything you do now in the workbook will be recorded,
- When you have finished click on the small blue square
within the macro recording box to stop recording.
- To run the macro go to
Tools -> Macros -> Macros.
To use the macro simply select it and click Run button.
|
