I select a column (e.g.
Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done
What happens: The protected range then switches to
Sheet1!A1:A100 (if there are 100 rows).
Naturally, I want to protect the entire column, to avoid fields in that column in new rows to be editable by certain users.
Is it possible to protect an entire column (
A:A)? If not, what is the logic behind that restriction?
(See also my question in the Google Product Forums.)