To protect cells, you first define which cells are to be protected and how extensive the protection is to be.
To do so, proceed as follows:
| 1. | Select the cell(s) whose protection settings are to be changed. |
| 2. | Click on the group arrow in the bottom right corner of the ribbon tab Home | group Number to open the dialog box. |
| Alternatively: Right-click to open the context menu and select the entry Cell. |
| 3. | Switch to the Protection tab. |
| 4. | Select the desired protection settings (see below). |
Tip: The options Protect cell and Hide formula can also be found directly on the ribbon tab Review | group Protection (as options Cell protection and Hide formula here).
The individual protection settings in the dialog box of this command mean the following:
▪Protect cell
| This option protects cells against changes. |
| If sheet protection is enabled, neither the content nor formatting of cells can be changed. |
Important: By default, this option is enabled for all cells in the worksheet. If you want certain cells to still be editable if sheet protection is enabled, select those cells and disable the option Protect cell.
▪Hide formula
| This option only shows the result and does not display the formula used to calculate the cell content. |
| If sheet protection is enabled, the calculation contained in this cell cannot be determined. |
▪Hide cell
| This option hides the cell content on screen. |
| If sheet protection is enabled, the cell becomes invisible. However, it still appears in the printout (see next option). |
▪Do not print cell
| This option hides the cell content in printouts. |
| If sheet protection is enabled, the cell will not appear when you print the document. |