In this article:

Switch to View-Only Mode in Google Sheets (2024 Guide)

How to Switch to View-Only Mode in Google Sheets

Switching to view-only mode in Google Sheets is a way to prevent accidental edits or changes to your data by others. Here are the steps to make a Google Sheets file view-only:

1. Open your Google Sheets file

Go to Google Sheets and open the document you want to set to view-only.

2. Share the file with specific people or get a shareable link

For specific people: Click on the Share button in the upper right corner.

google sheets view only mode

Enter the email addresses of the people you want to share the document with.

view only mode google sheets

Click on the dropdown menu next to their name and select Viewer. This will give them view-only access.

view only mode in google sheets

Click Send to share the document.

view-only mode in google sheets

For anyone with the link: Click on the Share button, then click on Change to anyone with the link.

view-only mode google sheets

In the dropdown menu where it says Editor, change it to Viewer. This will make the document view-only for anyone who has the link.

google sheets view-only mode

3. Configure advanced sharing settings

For more control over who accesses your file and how, click on the cog icon at the upper right corner of the sharing settings. 

change to view only mode in google sheets

Here, you can decide whether editors can change permissions and share the file, as well as whether viewers and commenters can see the option to download, print, and copy the spreadsheet. 

change to view only mode google sheets

We hope that this article has helped you and given you a better understanding of how to switch to view-only mode in Google Sheets. If you enjoyed this article, you might also like our articles on how to use the Google Sheets proper case function and how to apply conditional formatting for dates within 7 days in Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started