how to share google sheets with multiple people
IN SUMMARY
Sharing Google Sheets with multiple people is a straightforward process. You can share the sheet with specific email addresses or generate a shareable link. Adjust the access level to allow editing, viewing, or commenting as needed.
Sharing with Specific Email Addresses
Click on the 'Share' button in the top right corner of the screen. A sharing dialog box will appear.
In the 'Add people and groups' field, enter the email addresses or names of the people you want to share the sheet with. Separate multiple entries with commas.
Choose the access level you want to grant to the people you're sharing with. Options include 'Editor' (can edit and share), 'Commenter' (can view and comment), or 'Viewer' (can only view).
Sharing with a Link
In the sharing dialog box, click on the 'Get shareable link' option. This will generate a link that you can copy and share with anyone you want to grant access to the sheet.
You can choose whether the link allows editing, viewing, or commenting by clicking on the 'Viewer' dropdown menu and selecting the desired access level.
Copy the generated link and share it with the people you want to grant access to the sheet. They can click on the link to open the sheet with the specified access level.
Managing Access and Permissions
In the sharing dialog box, you can see a list of all the people and groups you've shared the sheet with, along with their access levels. You can change their access levels or remove their access from this list.
Click on the 'Advanced' option in the sharing dialog box to access additional sharing settings. You can disable options like sharing outside your organization, prevent editors from changing access, and more.
When sharing a sheet, you can choose to send an email notification to the people you're sharing with. This can be useful to let them know they've been granted access to the sheet.