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 cells whose protection settings you want to change. |
| 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. | Choose the desired protection settings (see below). |
Protection settings available:
Tip: The options Protect cell and Hide cell can also be found directly on the ribbon tab Review | group Protection (here as options Cell protection and Hide cell).
▪Protect cell
| Protect cell against changes, if sheet protection is enabled. |
| Use this option to prevent users from changing the content or the format of the cell. |
Important: By default, this option is enabled for all cells in the worksheet. To allow users to alter specific cells when sheet protection is enabled, select those cells and disable the Protect cell option.
▪Hide formula
| Do not display the formula used to calculate the cell content, but only show the result, if sheet protection is enabled. |
| When sheet protection is enabled, it is therefore no longer possible to find out which calculation this cell contains. |
▪Hide cell
| Hide the cell content on screen, if sheet protection is enabled. |
| When the sheet protection is enabled, the cell becomes invisible. However, it still appears in the printout (see next option). |
▪Do not print cell
| Hide the cell content in printouts, |
| if sheet protection is enabled. |