How to hide formulas in Excel

When you hide a formula in Excel, other people won't know if the cell uses the formula. And as such, they cannot edit the formulas they are using in Excel like when you lock the Excel formula. The following article will guide you to read how to hide formulas in Excel.

Instructions for hiding Excel formulas

Step 1:

In the Excel data sheet interface, click on the formula cell you want to hide in the data table, then right-click and select Format Cells in the displayed list.

Step 2:

In the new interface displayed, click the Protection tab and then click the Hidden check box . Click OK to save.

Step 3:

Back to the Excel interface, click the Review tab and select Protect Sheet . Now display a new interface, enter the password at Password to unprotect sheet . Click OK and re-enter the password.

The result when you click on the formula cell disappears and only displays the result. When clicked also cannot edit the content and is reported as shown below.

Step 4:

To unhide the formula cell, click the Review tab > Unprotect Sheets again . Finally, you can enter the correct formula key password set up earlier. Right after that, the formula cell will display again as it was originally.