Skip to main content

Macro in Microsoft Excel



A Macro in Microsoft Excel can be defined as a program that instructs Excel to perform action. In other words they are programs run by the application for which they are created. MS-Excel poses a feature which can record and play back command Macro. When you record a series of steps, Excel notches the steps and converts them into instructions.

Steps to perform Macro in Excel 2003 ::

Tools > Macro > Record New Macro (Record Macro dialog box appears) > Type the Macro name, also the shortcut key  > OK  (then a step recording dialog box appears) > Write down the structure that you want to be recorded.  > After completing it click stop recording button. > Open another blank sheet where you want the same sheet to be written. Press the Ctrl + and the shortcut key together to run the Macro.

Write down the structure that you want to be recorded. After completing it click stop recording button on the recording dialog box.



Comments