How to hide cell contents without having to protect the sheet
Cells can be hidden via the Cell protection tab but this protects the sheet as well. Sometimes, we want to hide some cells without protecting the sheet. That might be the case when we apply conditional formatting Icon set for example, in which values are represented by icons. In this case, it could be useful to hide the values and only show the icons.
- codes for numerical formats can contain up to three parts: the first part applies to positive values, the second to negative values and the third to the zero value.
- Defining the format
;;;will have the effect of displaying nothing.
- Creating a style dedicated to this layout will make it easier to apply.
Another possibility is to use the same font color as the one used for the cell background...