I have a question about formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-3069789%22%20slang%3D%22en-US%22%3EI%20have%20a%20question%20about%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069789%22%20slang%3D%22en-US%22%3EHow%20I%20hide%20all%20formulas.%20can%20not%20see%20in%20any%20formula%20cells%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20You%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3069789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor
How I hide all formulas. can not see in any formula cells

Thanks You
2 Replies

Hi @sf49ers164480 

 

in order to hide the formulas, first you need to set a checkbox in the format cells settings and second you need to protect the worksheet.

 

Here is an example.

Formual in B6 is visible:

DTE_0-1643009968209.png

Right-click in B6 and choose "Format cells...":

DTE_1-1643010002697.png

Open the "Protection" tab and tick the "Hidden" checkbox:

DTE_2-1643010039635.png

Open menu "Review | Protect Sheet":

DTE_3-1643010111186.png

...and just confirm all settings in the next window. If you want, you can also enter a password there (which you better not forget!)

DTE_4-1643010170767.png

Now the worksheet is protected an the formula in cell B6 is not visible anymore:

DTE_5-1643010210963.png

You need to repeat this for all formula cells.

Or you can just highlight all cells in your worksheet and do the formatting for all of them. But note, that by default all cells have also the "Locked" checkbox ticked. So you need to untick this checkbox for all cells where the user needs to enter something:

DTE_6-1643010353751.png

 

Otherwise all cells are locked.

 

 

 

 

Sorry to have waised your time I was looking for fendly helpnot a procedure R Sr