A macro is an action or a set of actions that we can run as many times as we want. When we create a macro, we are recording our mouse clicks and keystrokes. If we have tasks in Microsoft Excel that we do repeatedly, we can record a macro to automate those tasks.
To Record a macro in MS Excel, do the following:-
1. Open the spreadsheet.
2. Go to the “View” tab of the ribbon and click the tiny arrow below the “Macros” button under the Macros group.
3. Then click “Record Macro"
4. Type in the name of your macro and click “OK” to start the recording. The macro will be created.
5. When you’re done, go to the “View” tab, click the tiny arrow below the “Record Macro” button again and select “Stop recording”.
To Run a Macro in MS Excel
Once created, we need to run the macro. A list of macros can be accessed from the View tab. To view this list, do the following:-
1. Select the View tab
2. Click the button labelled Macros to bring up the Macro list
3. Select the macro you want to run from the list, then click the Run button. You can also show the Macro List at any time by pressing ALT+F8.
0 Comments:
Post a Comment