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.
