CODEWITHSUNDEEP
google-sheetsgoogle-docs
JohnH
JohnH

Reputation: 2133

How to change Google Sheet to "Viewing" while having "Editing" access?

For Gdocs, Edit access can be changed to Viewing to avoid unwanted changes.

enter image description here

How can that be done for Gsheets?

Upvotes: 3

Views: 2753

Answers (1)

Andron
Andron

Reputation: 685

There's no button in the UI for it, but there is a "Preview" mode available for Google sheets. To get to it you need to edit the URL.

The URL of a sheet in normal editing mode ends with something like ...sOmE-lOnG-ID/edit#gid=1234567. Remove the /edit and everything after it, and replace it with /preview. Hit enter to refresh the page.

It will load a data-only view, no toolbars or anything. Useful to avoid making any changes, though unfortunately there's no commenting feature like Docs has.

Upvotes: 6

Related Questions