Tuesday, December 26, 2023

Google Sheets annoyances: Protect sheet

Update of 2/15/2024: I discovered a simple way to do that. Under Range Edit Permissions you need to select "Show warning when editing this range" applied to the entire sheet. 

I am a very intensive user of Google Sheets.

It seems to be ridiculous that you can not easily protect a sheet within a spreadsheet from yourself (owner, editor) (e.g. accidentally modifying it). What about e.g. a lookup sheet that you don't want to be modified easily or inadvertently.

The available "Protect sheet and ranges" functionality does not appear to allow this in a simple, straightforward manner.

No comments: