Macro is set of instruction which are stored in Visual Basic module which will make excel to perform commands and actions for you by running them. Excel can repeat a task at any time by using macro. It allows to perform repetitive and complex tasks which you perform regularly.The easiest way to create a macro is to record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands. Click Tools> Macro > Record New Macro and enter new macro name and short cut key and click OK. Then start the action you want to get recorded and click STOP RECORDING on stop recording tool bar.