✦Template Printable Ideas Insights

How to Switch to Edit Mode in Google Sheets

By

Have you ever found yourself needing to limit access to a Google Sheets document, while still allowing certain individuals to view it? Google Sheets provides a convenient way to do this through its sharing settings. Here's a step-by-step guide on how to change view-only permissions in Google Sheets.

Before diving in, ensure you're using a Google account and are signed in to Google Sheets. If you haven't already, create a new or open an existing Google Sheets document for which you want to change the view-only permissions.

Understanding View-Only Access

View-only access is a feature that allows users to view the content of your Google Sheets document without being able to edit or modify it. This can be particularly useful when you want to share sensitive information or prevent accidental data loss.

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 change the date format in Google Sheets!
How to change the date format in Google Sheets!
How to Change Your Google Sheets Theme Color
How to Change Your Google Sheets Theme Color

In Google Sheets, by default, anyone with the link to your document can view and edit it unless explicitly restricted. Changing view-only settings allows you to control who can access your sheet and what level of access they have.

Changing View-Only Settings

Changing view-only settings involves navigating to the document's sharing settings. Here's how to do it:

The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
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
How to Create an Automated Google Sheets Dashboard
How to Create an Automated Google Sheets Dashboard

1. Click on the 'Share' button at the top right corner of your Google Sheets window. A panel on the right side of your screen will open, displaying the current permissions for your document.

Setting View-Only Access for Specific People

To give certain individuals view-only access:

1. In the 'Share with people' section, type the email addresses of the people you want to share the document with.

Handy Cheat Sheets – Microsoft Office | CustomGuide
Handy Cheat Sheets – Microsoft Office | CustomGuide
6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know
How To Create Checklists with Google Sheets
How To Create Checklists with Google Sheets
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
Google Sheets Checklists
Google Sheets Checklists

2. After adding each person, click on the dropdown arrow next to their email address, and select 'Viewer' from the list of options. This restricts their access to viewing only.

Managing View-Only Access for Everyone with the Link

In addition to specific individuals, you can also manage view-only access for anyone who has the link to your Google Sheets document.

Restricting Access to View Only

To restrict everyone with the link to view-only access:

the 13 google sheets shortcuts list is shown in green and has white writing on it
the 13 google sheets shortcuts list is shown in green and has white writing on it
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
Habit Tracker Template - Track Your Habits with Google Sheets - FREE Template
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets

1. At the bottom of the panel, click on 'Change' next to 'Anyone with the link'. A dropdown menu will appear.

2. Select 'Viewer' from the dropdown menu. Now, anyone with the link to your document, including people who you haven't explicitly shared it with, will only be able to view, not edit, your Google Sheets document.

Preventing Viewing with the Link

If you want to prevent anyone, even those you've shared the link with, from viewing your document:

1. In the same dropdown menu, select 'Restricted'. This will prevent anyone, even those with the link, from viewing or accessing your document in any way.

Remember to click 'Save' at the bottom of the panel to apply these changes.

Changes in access permissions can have a significant impact on your document's security and visibility. Always ensure that you've set the appropriate permissions for the right people, and that you're comfortable with everyone having the level of access you've granted.

Now that you know how to change view-only settings in Google Sheets, you can start managing access to your documents more securely and effectively.