How to Make Google Sheets Editable by Multiple Users

Mehvish Mushtaq is a computer engineer by degree. Her love for Android and gadgets led her to develop the first Android app for Kashmir. Known as Dial Kashmir, she won the prestigious Nari Shakti award from the President of India. She has been writing about technology for 6+ years and her favorite categories include how-to guides, explainers, tips and tricks for Android, iOS/iPadOS, social media, and web apps.

Supreeth is passionate about technology and dedicates himself to helping people figure it out. An engineer by education, his understanding of the inner workings of all types of gadgets and devices ensures he provides top-notch guidance, tips, and recommendations to his readers. When away from the desk, you will find him traveling, playing FIFA, or hunting for a good movie.

Google Sheets Sharing Settings: Explained

There are three levels ofsharing permissionsin Google Sheets:

You can only invite specific users to access the document, or let anyone with the link do so. Let’s begin with the former.

Also Read:How to see edit history in Google Sheets.

How to Provide Access by Specific Users Only

On Web

Step 1:Click on theSharebutton at the top right corner of your spreadsheet. Then, enter theemail addressof the person you want to provide access to.

Step 2:Click on thedrop-downmenu next to the name, and choose the type of access. Tap onSend.

The user will receive a link to access the document on their email address.

Tochangeorrevokeaccess – click onShareat the top right corner of your spreadsheet, and click on thedrop-downmenu next to the user with access. You can change the type of access, revoke the access, or transfer the ownership of the document to them.

Additionally, you can click on thesettings(gear) icon at the top right corner of the share window, and modify certain settings for editors, viewers, or commenters of the document.

Tip:You can always use theCopy linkbutton to quickly let the invited user access the document.

On iPhone/Android

Click on theshareicon, and enter theemail addressof the person you want to provide access to. Then, tap on thedrop-downmenu below the name, and choose the type of access.

To revoke or modify access — tap on thethree-dotsmenu icon in the share screen, and tap onManage Access.Tap on theuser, and select how you want to modify the permissions or remove them from accessing the sheet.

Also Read:How to use Duet AI in Google Sheets.

On Web

Step 1:Click on theSharebutton at the top right corner of your spreadsheet.

Step 2:Tap onRestricted, and change it toAnyone with the link.Click on thedrop-downmenu next to it, and select thepermissions. You can thenCopy the linkto the document and share it with users.

Additionally, you can click on thesettings(gear) icon at the top right corner of the share window, and modify certain settings for editors, viewers, or commenters of the document.

You can always use thesharemenu to change the permission settings or make it restricted once again.

On iPhone/Android

Tap on theShareicon at the top of your spreadsheet, and then tap on thethree-dotsicon and selectManage Access.Tap onRestricted, and change it toAnyone with the link.

Tap on the drop-down menu next toViewerand modify the access. Then, you can use thecopy linkicon at the top right and share the document with users.

Was this helpful?

Last updated on 26 April, 2024

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

3 Ways to Fix Instagram Not Working, Loading, or Crashing

13 Gmail Labels Tips and Tricks to Organize and Manage Them

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.