
To turn this on for the files inside, you have to change the settings for the files inside. Note: If you prevent sharing of a folder, it only applies to the folder.
Check the box next to “Prevent editors from changing access and adding new people.”. Learn more → How to make it so only you can share a Google Sheet Note: You can limit how people share, print, download, and copy within Google Drive, Docs, Sheets, and Slides, but you can’t stop how others share the file content in other ways, including copying and pasting contents from your file into another file. Check the box next to “Disable options to download, print, and copy for commenters and viewers.”. If you’re sharing a file, the owner or anyone with edit access can change the sharing settings for the file. To prevent commenters and viewers from downloading, printing, or copying your file: Next to the person, you want to stop sharing with, click Delete. At the bottom right of the “Share with others” window, click Advanced. You can also prevent people from making any changes or sharing your file. Add a note to explain why you are sharing the spreadsheet or to include any special instructions.ĥ – Send – Click the blue “send” button in the lower-left corner of the dialog box to share the spreadsheet Stop, limit, or change sharingĪfter you share a file, you can stop sharing it at any time. Advanced Settings: If you click the “Advanced” link in the lower right corner of the “Share with others” window, you can additionally prevent editors from changing access and adding new people, and disable options to download, print, and copy for commenters and viewers.Ĥ – Add a message (optional). Note: this is the default level of sharing in Google Sheets.
People can make changes, accept or reject suggestions, share the file with others, add or remove specific people, and copy, print, or download the file.
Comment: People can make comments and suggestions, but can’t change or share the file with others. People can view, but can’t change or share the file with others When you share a Google Sheet, you can choose what they can do with it.
However, only people with a Google Account will be able to edit the Google Sheet.ġ – Open the file you want to share and click the green “Share” button in the upper right corner of your screenĢ – Enter the email addresses for each person with whom you want to share your spreadsheet.ģ – Set sharing limits. You can easily share a Google spreadsheet with anyone via their email address. Google’s help docs include tips for mobile collaboration. This walk-through focuses on desktop sharing. Note: you can share a Google spreadsheet through a desktop browser or a mobile device.