✦Template Printable Ideas Insights

Remove View-Only Mode: Google Sheets Quick Tips

By

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:

the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
4 Ways to Remove Duplicates in Google Sheets
4 Ways to Remove Duplicates in Google Sheets

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.

Google Sheets - Delete Empty Rows (Blank Rows)
Google Sheets - Delete Empty Rows (Blank Rows)
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
How to Use the VLOOKUP Function in Google Sheets
How to Use the VLOOKUP Function in Google Sheets

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'.

Insert a Checkbox in Google Sheets
Insert a Checkbox in Google Sheets
Expense Tracker | Google Sheets Tutorial ✨ what’s best? Its mobile-friendly!📱
Expense Tracker | Google Sheets Tutorial ✨ what’s best? Its mobile-friendly!📱
Why You Should Switch From Excel to Google Sheets
Why You Should Switch From Excel to Google Sheets
How To Create A Filter in Google Sheets Mobile?
How To Create A Filter in Google Sheets Mobile?
How to use VLOOKUP in Google Sheets: A complete guide
How to use VLOOKUP in Google Sheets: A complete guide
Remove Duplicates in Google Sheets (2 Quick and Easy Ways)
Remove Duplicates in Google Sheets (2 Quick and Easy Ways)

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.

How to Use VLOOKUP in Google Sheets
How to Use VLOOKUP in Google Sheets
How to change text case in Google Sheets with UPPER/ LOWER/ PROPER
How to change text case in Google Sheets with UPPER/ LOWER/ PROPER
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma
How to use an Excel spreadsheet in Google Sheets (access from any device, anytime) or Numbers for Ma

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.