K
K
Kulver_stukas2017-06-26 12:05:29
excel
Kulver_stukas, 2017-06-26 12:05:29

How to disable editing of individual cells in a table sheet?

Office 2016. For some reason, setting protection on a sheet makes it possible to either prohibit editing the entire sheet or remove the prohibition of the entire sheet. Like in old offices it was possible to protect a separate cell?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2017-06-26
@Kulver_stukas

For cells that do not need to be protected, you should uncheck the "Locked" checkbox in the properties on the last tab "Protection", or as it will be in Russian.
bfe25ed609944c04a4824bb133f84bb2.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question