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

