Details of Macros in Microsoft® Office Excel 2010
What is the significance of Macros in Microsoft Office Excel 2010?
Macros are a very useful feature of Microsoft Office Excel 2010, especially if you find yourself constantly repeating the same tasks on different cells, or worksheets. It enables you to record repetitive actions and repeat the actions at the click of a button. In a way, Macros are like simple programs or batch files. Some applications support sophisticated macros that even allow you to use variables and flow structures such as loops. When you start up the Microsoft Office Excel 2010 and perform a certain number of tasks that you repeat daily, then you can have these tasks saved as a Macro and then simply run the Macro the next time you need to perform these tasks. A Macro will record your mouse clicks and keystrokes and playback at a later time when required. Macros may be application specific or general-purpose.
The ways to run and create a Macro in Microsoft Office Excel 2010 are:
- Create Macro to an 'Option' button
- Create a Macro using Microsoft Office Excel 2010 Macro Recorder
- Run a Macro
- Easier method
Create Macro to an Option button
Add the 'Developer' tab on the ribbon, under the Developer tab, in the 'Controls' category, click on 'Insert' icon in the 'Form Controls' group. To insert the button, click on any particular portion of the worksheet where you want to insert it. While you insert the button, an 'Assign Macro' dialogue box appears on the Screen. In this dialogue box, select the Macro that you want to assign to the 'Option' button and click 'Ok'. Click on the 'Option' button that you inserted on the Microsoft Office Excel 2010 worksheet and Macro that you selected in the previous step will automatically run.
Create a Macro using Microsoft Office Excel 2010 Macro Recorder
Insert the 'Developer' tab in the ribbon of Microsoft Office Excel 2010. In the Developer tab click on 'Record Macro'. A 'Record Macro' dialogue box appears on the screen in this dialogue box, give a name for the Macro, specify a shortcut key to run the Macro later and the location where you want store the Macro and a brief description about the Macro and finally click the 'Ok' button.
To run a Macro that you created, click on the 'Macros' icon that you find on the 'Developer' tab under the 'Code' category. Now a Macro dialogue box appears on the screen, which contains a list of Macros. Select the Macro that you created from the List and click on the 'Run' tab. Now the Macro will be run on the worksheet. You can run the Macro on any worksheet of the workbook.
You can also run the created Macro by using the shortcut key that you specified while creating the Macro. It is an easier method to run Macros in Microsoft Office Excel 2010. If you forgot to assign a shortcut key, simply head over to 'View Macro', select the desired Macro and press 'Options', now assign a hotkey and then press 'Ok'. If you do not use hotkeys, simply add the Macro in the 'Quick Access Toolbar'.
iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction. Our award winning and low priced Annual Subscription covers the following services:
- Comprehensive support Macros on Microsoft Excel 2010
- Diagnostic & repair for your technologies.
- Troubleshoot software errors.
- Update drivers and security to protect against online threats.
- Connect to Internet, devices and peripherals.
- Optimize your computer’s speed and performance.
Unlimited access to great tech support, all year around! We promise the lowest wait-time and highest resolution rate in the industry.