Should there be more protected ranges

Google Sheets
1

Hi,

Last week I noticed that the “total expense” wasn’t being updated when changing the “insights for” range on the “spending trends” sheet. Turns out, the value was pasted accidentally when copying the cell to paste into something else.

It looks like making this cell protected doesn’t have any drawbacks. Should all cells except for the few in the “insights for” row be protected in the sheet?

And a more overarching question, is there a reason protected ranges aren’t used more than they are?

Thanks,
-Chris

3

Good question, and good idea @ChrisMildebrandt ! We currently just recommend that only green highlighted cells are modified.

1 Like