How To Make Google Sheet Read Only

The owner of the google sheets file needs to open the advanced sharing settings.

How to make google sheet read only. How to make a file read only. I want to make a sheet publicly available but with read only access for anyone but me. Go ahead to click review protect sheet. Select restrict who can edit this range and set it to only you or add others from the custom option. You don t want to lose it by deleting it mistakenly and for safety reasons want a warning message before deletion or for any other reason.

We can do this by making sure other users can choose the option of read only mode to decrease but not eliminate risk of the file being changed. Go to the file tab and select save as. You can add other people with their gmail address or select from a list depending on how you have google sheets set up. This code will read data from your google sheet and store this. Kiml42 aug 15 19 at 15 22 kiml42 yes the permission is called view only aurielle perlmann aug 15 19 at 20 32.

Solution 1 print preview mode use the preview endpoint which is a read only view. Now select the cells you want to make them as read only here i select cells of range a1 c18. You create a file and put some important things in it. Open the sharing link option then click on advanced in the lower right corner then a new box will open and you will see whom all has a link shared. Press the ctrl 1 keys simultaneously to open the format cells dialog box check the locked box under the protection tab and click the ok button.

They can also choose the set expiration date if they want to that can either be seven days 30 days or even customize it. Once you make these changes authentication link will come once you run the code so authenticate by logging to your google account. The first step in how to make a file read only is to enable the setting. Select done once finished.