Questions tagged [google-sheets-protection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
29 views

How to prevent anonymous users from creating new rows

I have a Google sheet that I need to allow anonymous users to access. I have locked down all cells bar 3 that I want people to be able to edit. Unfortunately, people can still right click and create ...
1
vote
0answers
22 views

Google Sheets: How do I protect a sheet without locking its sheet name?

I have a Google Sheets workbook in which I need to protect all cells for data purposes. However, I need restricted users to be able to change the tab title of the individual sheets’ names. Does anyone ...
9
votes
1answer
28k views

Can I protect the formatting of a Google Sheets?

I’ve got a Google Sheets that has lots of formatting and formulas, in various columns, some columns are formula driven, and some columns that are user input driven. The spreadsheet is shared with ...
1
vote
0answers
21 views

How to give owner of copied Google Sheets doc same permissions as he has in the folder it's copied to?

We have a master form in Google Sheets that is copied by team members and shared with their clients to be filled in. We are using personal Google accounts associated with work emails, not G Suite ...
11
votes
1answer
21k views

In Google Sheets how do I duplicate a sheet along with its permission

In a Google Spreadsheet called Attendance there is a sheet called Template. The user duplicates this sheet, renames the sheet with current date and uses this sheet to mark attendance for students. The ...
2
votes
1answer
3k views

Remove Protection from Range

I have created 50 spreadsheets for 50 students. Each spreadsheet contains 33 sheets, numbered 1 to 33, along with a couple of other sheets. Within each of these 33 sheets, there are many protected ...