Ever found yourself collaborating on a Google Sheets document, only to realize that some of your team members can only view your changes, but not modify them? Here's how to remove 'view only' access and ensure everyone can work together effectively in Google Sheets.
Firstly, it's crucial to understand how view-only access happens. When you share a Google Sheet, you have the option to grant 'view', 'comment', or 'edit' permissions. If you've set permissions to 'view', users can only look at the file, not change it. This guide will walk you through the process of changing these permissions.
Modifying Share Settings
Google Sheets' share settings allow you to change user permissions easily. Here's how to access them:
1. Open the Google Sheets document in your Google Drive.
2. Click on the 'Share' button at the top-right corner of your screen. This will open the 'Share with people and groups' window.
Changing Individual Permissions
If you want to change the access level for specific people:
1. In the 'Share with people and groups' window, find the name of the person whose access level you want to change.
2. Click on the dropdown arrow next to their name to change their access level to 'Editor'.
Changing Permissions for Everyone
If you want to change the access level for everyone your sheet is shared with:
1. Under 'General access', click on 'Change'.
2. Select 'Anyone with the link' or 'Anyone in the organization' or 'Public on the web', depending on who you want to have editing access.
3. Below this, find the 'Access column' and click the dropdown arrow. Change 'Viewer' to 'Editor'.
Understanding Edit vs Comment vs View Access
Before you make changes, it's important to understand the different access levels:
1. **Editor**: Can make changes, including formatting, to the document.
2. **Commenter**: Can view and comment on the document, but not make changes to it.
3. **Viewer**: Can only view the document, not make any changes or add comments.
Using the ' истории' Feature
The 'history' feature in Google Sheets allows you to see who made what changes and when. This can be particularly useful when you want to revert unwanted changes.
1. Click on ' Tools' in the menu.
2. Select 'Version history'.
3. Click 'Name' at the top of the panel to filter changes by a specific person.
With these steps, you should now be able to remove 'view only' access and collaborate effectively with your team in Google Sheets. Always review and adjust sharing settings as needed to maintain control over your documents.