Page 221 - IT 402 v2.0 class 10
P. 221
Step 13: Select the newly created ‘Multiply3’ and then enter the macro name ‘PasteMultiply’.
Step 14: Click on ‘Save’ button.
Sneak Peek
MS Excel provides a developer tab to work with macros. By default, it is not activated in excel.
Follow these steps to activate the Developer tab.
1. Click on File Options. A new dialog box appears.
2. Find the customize ribbon from the dialog box.
3. Find the main tabs then Developer checkbox.
4. Click on the Developer checkbox.
5. Click on the OK button.
How to Create a Macro in MS Excel?
1. Place the cursor in the cell you need to start with.
2. To start the process, click on the Developer Use relative references to copy the relevant cell
address of the worksheet.
3. Now click on Developer Record Macro. Now record macro dialog box will appear.
. Now fill the following fields in the dialog box:
Macro name: Give a name for your macro.
Shortcut key: You can assign a shortcut key for the macro.
Store macro in: It provides three locations to store your macro as follows:
Personal macro workbook
New Workbook
This Workbook
Description: You can write a brief description of your macro.
5. Click on the OK button. It will display two buttons that indicates recording is started.
6. Now type formulas and do changes in the worksheet.
7. Click on the Stop recording button.
More About Spreadsheet 219

