✦Template Printable Ideas Insights

Disable View-Only Mode: How to Edit Google Sheets

By

Ever found yourself wanting to make edits on a Google Sheets file that's been shared with you, only to realize it's in 'View Only' mode? You're not alone. Google Sheets often defaults to 'View Only' for shared files to prevent accidental edits. But what if you need to make changes? Here's how you can turn off 'View Only' mode and make those much-needed edits:

Before we delve into the process, it's crucial to understand that turning off 'View Only' mode will give you edit rights. Be sure to use this privilege responsibly and communicate with other collaborators to avoid conflicts. Now, let's get started!

Requesting Edit Access from the Sheet Owner

If you're not the owner of the Google Sheets file, you'll need to ask the owner to grant you edit access. Here's how you can do it:

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
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
someone is typing on their laptop with the words more crap that you should know how to do in google workspace
someone is typing on their laptop with the words more crap that you should know how to do in google workspace

1. At the top right of the screen, click 'Share' or the share icon.

2. Under 'Shared with me', find the file's owner and click their name.

Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
How to change the date format in Google Sheets!
How to change the date format in Google Sheets!
15s Google Sheets Trick To Make You A Pro!
15s Google Sheets Trick To Make You A Pro!

3. In the 'Access rights' section, change the setting to 'Can edit'.

4. Click 'Done' to save your changes.

Getting the Sheet Owner to Change Sharing Settings

If you're unable to change the sharing settings yourself, you might need to reach out to the sheet owner to do it for you. Here's how you can ask them:

Why You Should Switch From Excel to Google Sheets
Why You Should Switch From Excel to Google Sheets
How to Use VLOOKUP in Google Sheets
How to Use VLOOKUP in Google Sheets
How to Change Your Google Sheets Theme Color
How to Change Your Google Sheets Theme Color
Google Sheets Checklists
Google Sheets Checklists
How to Use the SORTN Function in Google Sheets
How to Use the SORTN Function in Google Sheets
10 Google Sheets Tips & Tricks To Make Life Easier - ONLC
10 Google Sheets Tips & Tricks To Make Life Easier - ONLC

1. Open the shared Google Sheets file.

2. Click 'Share' at the top right of the screen.

3. Under 'Shared with me', find the owner's name and click it.

GOOGLE SHEETS TIPS
GOOGLE SHEETS TIPS
Google Sheets Tips and Tricks!
Google Sheets Tips and Tricks!
Simple To-Do List Setup in Google Sheets for Beginners
Simple To-Do List Setup in Google Sheets for Beginners
Insert a Checkbox in Google Sheets
Insert a Checkbox in Google Sheets

4. In the 'Request access' dialogue, type a polite message asking them to change your access to 'Can edit'.

5. Click 'Send request'. The owner will receive a notification and can update your access level.

Viewing and Managing Share Settings

As the owner or an Editor, you can view and manage share settings to control who has access to your Google Sheets file and what permissions they have. Here's how:

1. Open the shared Google Sheets file.

2. Click 'Share' at the top right of the screen.

3. In the 'General access' section, you can set who can access the file and their access level (Can view, Can comment, or Can edit).

4. In the 'Shared with specific people' section, you can add or remove people and adjust their access level.

Understanding 'View Only' Mode and Other Access Levels

Before we wrap up, let's quickly cover the different access levels in Google Sheets and what they mean:

1. **Can view**: These users can open the file to view its contents but cannot make any changes.

2. **Can comment**: These users can view the file and leave comments, but cannot make edits unless they request access to edit the file.

3. **Can edit**: These users can view and edit the file. They can also change the sharing settings and invite others to edit the file.

That's it! Now you should be able to turn off 'View Only' mode and start editing your Google Sheets files. Always communicate with your collaborators to avoid any confusion or conflicts, and enjoy using Google Sheets with the right access level. Happy editing!