Ways For Building Macros In Excel 2010.
![qa-featured](https://www.techyv.com/sites/default/users/superadmin/qa-featured-300x270.png)
I stand novel to macros and am in necessity some assistance in building macros in Excel 2010. Please help me in a step by step manner to enable me to create a macro to automate many of my tasks.
![](https://techyv.com/sites/default/2016/10/techpedia_logo.png)
I stand novel to macros and am in necessity some assistance in building macros in Excel 2010. Please help me in a step by step manner to enable me to create a macro to automate many of my tasks.
A macro is used to assign a shortcut key or a button to perform some task repeatedly that may be pre-programmed or pre-recorded. Follow the given steps.
Step1: Click on View–>Macros and select Record macro
Step 2: Give your macro a name and select a shortcut key
Step 3: Perform the tasks that need to be recorded
Step 4: Click on the stop recording button to stop the recording
Step 5: Now you can use the shortcut key to perform the same recorded steps several times.