How to Change Access to Shared Sheet
Learn how to change access permissions for users on your Google Sheets, whether it's switching from editor to viewer or vice versa. This quick guide will help you manage your shared sheets effectively.
You've already added someone to your sheet. They have access to it, but you want to change their access either from editor to viewer or viewer to editor or commenter to viewer . Either way, here's how to do it. So click up on share in the top right corner where it says shared with one person or shared with however many people are shared. Click on that share button next to their email address. You'll see a drop down menu. It'll have a downward facing triangle. Click on there and you can change editor to viewer and you must save these changes. You can also add an expiration if you wish or even remove access completely. Either way, you must save these changes. And it'll say access updated. If it gives you an error message, it has not been updated. Announcing OnlySheets 2.0 Getting Started in Google Sheets Spreadsheet Management How to Change Edit Access in Google Sheets