Protect and hide formula in MS Excel Tutorial

Protect and hide formula in MS Excel Tutorial

Today let us learn how to hide formula in MS Excel.

Here the cells with red border are the cells where we put a
formula.

We will be able to see the formula contained in each cells
by selecting the respective cells.

To hide the formula in each cell.

First, select the whole work sheet by clicking on a cell and
pressing control + A.

Now right click,  select format cells, under  the protect tab, uncheck Lock and Hidden

Now select the Range of cells  where you want to hide the formula.

Right Click , select,  format cells, under the protection tab, checked,
Lock  and hide, then press, Ok.

To hide the formula you have to protect the sheet.

Go to the Ribbon Menu at , Review tab, click protect sheet,

In the pop up dialog,

Checked,  Select
locked cells,

Checked, select unlocked cells,

Typed your password, (any password of your choice to edit but
remember the password)

Again typed your password,

Clicked ok, (Now the sheet is protected and formula hidden and that's it)

Now click on the formula cells, the formula are hidden, so
it does not, show up, in the, formula bar, but you cannot edit the formula.

To edit the formula,

First You have to unprotect the sheet, 

Click on the unprotect sheet found under the reveiw tab.

Enter the password then click OK.

Now after disabling the Protection you will be again able to edit the formula.

But 

After editing dont forget to  again protect the sheet, so that, the hidden
formula, is again active .

Now anyone working on this sheet will not be able to view,
or change the hidden formula.