V
V
Vol_yu_me2020-02-09 01:05:43
Data protection
Vol_yu_me, 2020-02-09 01:05:43

Google sheets. How to protect rows and columns from deletion?

Hello! Can you please tell me how to protect a sheet from deleting rows and columns in Google spreadsheets? In Excel, it is configured first through a cell (a certain checkbox is set) and then through the "Protect Sheet" button. In Google spreadsheets, I found only how to protect ranges and sheets, but with the option either the author can do all the actions, while others cannot; or before ANY change (to make, for example, a value in a cell), a warning is issued that the user is trying to change the protected range.
My task: users should be able to fill in the data in the cells, but should not be able to delete rows and columns, otherwise the document will fly into which the field merging is configured.
I will consider any life hack. Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Sergey Sokolov, 2020-02-09
@sergiks

Maybe make a form, filling which users can make new entries in the table?
And the table itself with the data can be seen and edited only by those who will not break anything.

D
Dimonchik, 2020-02-09
@dimonchik2013

protect in no way
only by post-processing data

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question