Reply To: Macro-The most useful feature of Excel

Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Macro-The most useful feature of Excel › Reply To: Macro-The most useful feature of Excel

March 1, 2020 at 8:06 pm #24849
Mayank Goyal
Keymaster

    Singhprabhjot wrote:

    A Macro is program or a code which is used to automate tasks that you repeat a lot in Excel. It is typically used to replace repetitive keyboard and mouse actions .

    If you have tasks in Excel that you do repeatedly, you can record a macro to automate those tasks. When you create a macro, you are recording your mouse clicks and keystrokes.

    It is very easy to record a Macro in Excel.

    Firstly you have to enable Developer Tab by going to File Tab > Options > Customize Ribbon.

    Then click on the Developer tab, click Record Macro .

    You can enter a name for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording.

    Then you can perform the actions you want to automate.

    Then on the Developer tab, click Stop Recording to stop recording.

    Thanks for sharing!!

    Sent from my LLD-AL10 using Tapatalk