Cell with secret

Let's look at reception which help us to hide the cell content without sheet protection. Nevertheless, the value will be shown in the formula bar and the cell will take part in calculations.

But it's not banal assignement white color to the text. We'll go another way. Open Cell formatting, and in the tab Number in the window Number formats choose All formats. And in the graph Type enter three semicolons ;;;. Press and cell text is hidden.

How to use given trick - you decide.