October 20, 2021

How to share a Google Sheet

In this lesson we will learn how to share a Google Sheet. To share a Google sheet follow the below process.

  • Click the ‘Share’ button at the top right corner of the Google Sheet.

  • The below pane will appear. Here if you want to share this google sheet with more people except you then you can add the email ids for them in the top panel.
  • If you want to share with anyone who will have the link of this google sheet then click ‘ Change to anyone with the link’ in the bottom panel.
  • You can get the link of this Google sheet by clicking ‘Copy Link’ in the bottom panel of the below pane.

  • If you are going for the option to share this google sheet to anyone who has the link then you can also control the access level for them by selecting Viewer/Commenter/Editor from the following dropdown.
  • As you can understand by name, with Viewer access, the people having the link can only view this google sheet but cannot comment or edit.
  • With Commenter access, the people having the link can only view & comment to this google sheet but cannot edit.
  • With Editor access, the people having the link can view, comment & edit this google sheet.

  • The same access levels you can also specify for the individuals if you are sharing the google sheet with email ids.
  • Here you can see there is a checkbox ‘Notify people’. It is selected by default. It means once you are done with adding email ids of the people you want to share this google sheet and then click ‘Send’, the people will receive the email notification. If you don’t want them to receive email notification, you can uncheck this ‘Notify people’ checkbox.

  • In the top right corner of the above pane there is a settings icon. If you click the same, the below screen will appear. You will find two checkboxes here. By default both are selected.
  • If you don’t want the editors to change the permission and share this google sheet then uncheck the corresponding first checkbox.
  • If you don’t want to provide the option to download, print and copy the google sheet for the viewers and commenters then uncheck the corresponding second checkbox.
  • Click back arrow to go back to the main share pane.

  • Finally you can click the ‘Done’ button available in the pane to share the google sheet based on your selection.
  • Or any time if you want to leave the share pane then just click anywhere in the google sheet outside the pane. The share pane will be disappeared.

You can also check here to learn how to share an Excel workbook.

Leave a Reply

Your email address will not be published. Required fields are marked *