baszee.blogg.se

How to use microsoft excel protect cells from editing
How to use microsoft excel protect cells from editing












how to use microsoft excel protect cells from editing how to use microsoft excel protect cells from editing

It is also locked to prevent users who do not have permission to work on a document from rewriting data. Click on OK to apply the changes: Checkbox to lock cellsĪgain, locking a cell means that it is impossible to modify what is written in the cell it is not possible to rewrite or change attributes of the cell, such as formatting.Ĭell locking can be useful in situations where you are working with a large amount of sensitive data, where changing a number or a character by mistake can ruin a huge amount of working hours by changing the final result, and therefore, its interpretation.

how to use microsoft excel protect cells from editing

In this tab, select the Locked check box so that the contents of the selected cells cannot be altered. There, go to the Protection tab: Location of the Protection tab














How to use microsoft excel protect cells from editing