Page 37 - Computer_Genius_v2.1_C7_flipbook
P. 37

4  Select the
                                                                                                     Commands Not
                  3  Select the Customize                                                            in the Ribbon
                  Ribbon option from  the                                                            option from
                  left pane.                                                                         the Choose
                                                                                                     commands
                                                                                                     from drop-down
                                                                                                     list.
                  6  Scroll down and select
                  the Form command and
                  then click on the Add>>                                                             5  Select the
                  button.                                                                            Insert tab and
                                                                                                     click on  the
                                                                                                     New Group.




                                                                          7  Click on the OK button.








                 The Form command will appear under the Insert tab on the ribbon.

                 Using Form in Excel

                 As you know that you can add, update and delete a record using a form. A form displays only one
                 record at a time. To perform all these operations, first you need to create an Excel worksheet and
                 enter the desired data.

                 Adding a New Record

                 Perform the following steps to add a new record:

                                                                  2  Click on the Form
                                 1  Click on the Insert tab.      command from the ribbon.







                      3  Click on the
                      New button.



                                                                                              4  Enter the details
                                                                                              and  click on  the
                                                                                              Close button.

                 Record will be added in the worksheet.


                                                                             Advanced Features of Excel 2016  35
   32   33   34   35   36   37   38   39   40   41   42