what is 'macro' in excel? how to make use of it ?



what is 'macro' in excel? how to make use of it ?..

Answer / Sudheer Kumar

A macro is a series of pre-recorded instructions or actions within Excel that can be reused to perform repetitive tasks more efficiently. To create and use macros, follow these steps:n
1. Enable the Developer tab in Excel by going to File > Options > Customize Ribbon.
2. Click on Developer in the list of options on the right side, and then check the box for 'Developer' in the new section that appears.
3. In the Developer tab, click on Visual Basic to open the VBA Editor.
4. In the VBA Editor, you can write your own macro code or record a series of actions by pressing Alt + F11 and then clicking on 'Record Macro' in the Insert menu.
5. Save your macro by clicking File > Save.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Microsoft Related AllOther Interview Questions

What is SNMP ?

1 Answers   CTS,


Can you delete a microsoft account?

1 Answers  


How to create virtual root in iis?

1 Answers  


In My org. i have 5 OU's each are having more than 50 users i want to apply different type of policy to different users in a single OU how? I am using GPMC tool ..plz mail me asap..

1 Answers   HP,


What is the cycle of Installing patches.....

1 Answers   HP,


Enumerate the high level elements of the <system.serviceModel> section

1 Answers  


Because of virus in windows 7 my general folders are system hidden now. i've remove the virus but folders are still hidden. can i make that system hidden folder as nornal any how?

1 Answers  


What is Docking Station ?

1 Answers   Cummins,


DOTNET -> WPF what is Freezable?

1 Answers  


What are FMSO Roles? List them...

4 Answers   DynPro,


What is microsoft's web browser?

1 Answers  


What is SSL (Secured Sockets Layer) ?

1 Answers  


Categories