Macros

What is a macro in excel?

• A macro can be defined as the recording of a serious of tasks.
• It is the simplest form of automation-show a software program the steps we follow to get something done.
• Macros can save us hours by automating simple, repetitive tasks.

How to create macro in excel?

• Make sure you know how to perform each action you want to record before recording.
• The macro will record every keystroke and mouse click, including mistakes. This will repeat every time we run a macro.

• In the VIEW tab, click on Macros a drop down will appear. Select Record Macro.

• A Record Macro dialog box will appear. Name the macro and select a short key that will be used to run the macro.

• An recording icon at the bottom left is found after clicking OK. Start performing the actions we want the macro to automatically do for us.

• After finishing, click on the recording icon at the bottom left to stop recording, or in the VIEW tab click on Macros and Select Stop Recording.

• Test it by pressing the short key in the same sheet or in the other sheets of workbook. 

• To view the macros press Alt + F8. A Macro dialog box will appear.