Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 77 - 2619_PlusGPT V2.1_C-7
P. 77

    SHARING A FILE

                     Google Sheets allows you to share your spreadsheet with others for collaboration. You can control
                     who can view, comment, or edit the file.
                     Perform the following steps to share a spreadsheet:

                     Step 1:   Click on the Share button from the top-right corner of the spreadsheet. The Share dialog box
                             opens.
                     Step 2:   Enter  the  email  address(es)  of the
                             people with whom you want to share the

                             spreadsheet in the box.
                     Step 3:   Click on the down-arrow to give
                             permission. A drop-down list appears
                             with the  Editor, Viewer or  Commenter
                             options.
                                                                                                 Sharing a file
                     Step 4:   Select  the  desired  option  from the
                             drop-down list. In our case, we have selected Editor.

                     Step 5:  Type a message for the receiver in the Message box.
                     Step 6:  Click on the Send button to share the file.
                     This spreadsheet will be shared with the specified people.

                                                              Tech Hint

                                   To share a spreadsheet: Select the Share option from the File menu.

                            PROTECTING DATA

                     Google Sheets allows you to protect data to prevent accidental changes or unauthorised edits. You
                     can lock specific cells, sheets, or the entire document while allowing others to view or edit only certain

                     parts. Perform the following steps to protect a spreadsheet:
                     Step 1:  Click on the Data menu.

                     Step 2:  Select the Protected sheets and ranges option. The Protected
                             sheets & ranges pane appears.
                     Step 3:  Type the description of the spreadsheet.

                     Step 4:  Specify the sheet address or cell address with the sheet address.
                     Step 5:  Click on the Set permissions button.

                     Step 6:  Select the desired radio button to specify the edit permission.
                     Step 7:  Click on the Done button after setting permission.
                                                                                                      Protecting data

                                                                                           Introduction to Google Sheets  75

| 72 73 74 75 76 77 78 79 80 81 82 |