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
   216   217   218   219   220   221   222   223   224   225   226