Page 67 - PlusGPT_V2.1_C8_Flipbook
P. 67

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


                                                                                                   Google Sheets   65
   62   63   64   65   66   67   68   69   70   71   72