Questions tagged [google-sheets-protection]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
23 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 ...
1
vote
0answers
25 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 ...
1
vote
2answers
55 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 ...
11
votes
1answer
31k 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 ...
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 ...
12
votes
1answer
23k 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 ...