TOP

A cell with a secret

Description

Let's look at a technique to hide the contents of a cell without protecting the sheet. However, the value will be displayed in the formula bar, the cell will participate in the calculations.

But this is not a banal assignment of a white font to the color of the text. We will go another way.


We open " Cell format ", and in the tab " Numeric » in the window "Numeric Formats" let's choose "(all formats)" . And in the count "Type" enter three periods with commas ";;;" . We press «ОК» and the cell text is hidden.

How to use this trick is up to you.

Related Articles: