

How to amend sharing settings for a person or group for a Google Sheets spreadsheet After that you can follow the steps described under “How to share a Google Sheets document (spreadsheet)” section of this article. Then right click on the selected area to call the sharing pop-up window. To share multiple Google Sheets files, hold Shift on your keyboard and pick several files.
#Google docs master editor update#
Set up the automated spreadsheet update in a few clicks with Coupler.io How to share multiple Google Sheets files What sheet will a user land on after I share the document?īy default, a user with whom you shared the link to a spreadsheet by either giving it to them or sending them an email notification (if you picked “Notify by name”), will land on the first sheet (tab) of your Google Sheets spreadsheet. By default, the latter has the Viewer access rights enabled (but I would recommend to being very attentive when adjusting the sharing settings in this). “Anyone with the link” - is when anyone with the link can view, comment or edit the document without signing in to a Google account.If you picked this option, you can also navigate and click on the settings gear located in the top-right corner of the “Get link” part of the pop-up, and tick the box if you want to let people in your organization be able to search for your spreadsheet. “Google organization / group” - sharing a document with your company or department specifying the access rights.Restricted - when access to the document is restricted to those emails and groups that you’ve specified in the “Share with people and groups” pop-up.Google allows you to pick between the following options: In the drop down, pick either “Restricted”, “Your Group / Organization” or “Anyone with the link”.To change this default setting, click “Change”.In my case, this file has been shared with the entire Railsware Google group, so that its members have “Viewer” permissions for it. There you will see whether this document is already shared with a Google group - for example, an organization or department.Navigate to the bottom part of the pop-up.Or, you may open the document, navigate to the top-right corner and click “Share”.Īfter the “Share with people and groups” pop-up opens, please: To find it, you may either locate your file in the Google Drive, right click on it and then select “Get link”. Once you’ve shared your document, you may need to get a shared link to it. How to get a shareable link to a file in Google Sheets Editor can view, share, and edit the document.Commenter can view and leave comments (can’t share or edit it).Viewer can only view your document (can’t share or edit it).Google supports three types of user permissions: Viewer, Commenter and Editor.

User permissions when sharing the file: how it is shared and managed At this point, the pop-up window will close.You can either keep it and send a notification email to them, or clear the checkbox and then press the “Share” button. Under the list of users who you want to share the document with, you will see the ticked by default box “Notify people”.By default, Google suggests assigning the Editor permission. Choose the access rights that you give to the account holder (a group).Add emails of people or groups that you want to share the document with.Once the “Share with people and groups” pop-up opens: Alternatively, you can open the document first and then click the “Share” button located in the top-right corner. The first step is to go to your Google Drive and find the spreadsheet you want to share. Conclusion How to share a Google Sheets document (spreadsheet)
