How To Make Google Sheets View Only

So on the weekends it would be locked for editing.

How to make google sheets view only. Select done once finished. They could edit the document only from monday 8pm to friday 2pm. The row numbers and column letters will turn a dark gray color when activated. Share a link to this answer. There you can see the list of all the previously saved filter views.

You can add other people with their gmail address or select from a list depending on how you have google sheets set up. Allow selecting copying pasting and right clicking in some restricted sheets. Once you ve turned link sharing on a drop down appears to select what public users can do either view only view and comment or full edit access. This will work for google docs google slides google sheets google forms and google dra. Even though google sheets is available on your mobile devices requesting access to edit can only be done from the computer.

Request access from google sheets. Just click on the close x button on the top right corner of the black bar next to the options icon. Select restrict who can edit this range and set it to only you or add others from the custom option. Also even though google sheets supports working on your files offline you need to be online to ask for editing permission. I need to create a document something like a google sheets where multiple users could insert their names but within a limited time span.

Fire up google sheets and open up a spreadsheet to get started. If you need to re apply the same filter view at some point in the future just click on the drop down next to the funnel icon on the menu bar. Click data filter views create new filter view. You can click it to access the link sharing popup in which you can set it to be publicly accessible to those with the link. At this time you should give your filter view a name to distinguish it from any other views you make in the future and check the range is correct.

Here s what you do.