Page 241 - Trackpad 402_Class-X_Final
P. 241

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.
                     4.  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.






                                                                                 Electronic Spreadsheet (Advanced)  241
   236   237   238   239   240   241   242   243   244   245   246