How to hide formulas in Excel

Hiding formulas in Excel is one of the ways to secure Excel files, avoiding others from viewing formulas and still seeing other content, in case you have to set a password for the Excel file when you have to enter the correct password. can see all the contents of the Excel file.

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.

How to hide formulas in Excel Picture 1 How to hide formulas in Excel Picture 1

Step 2:

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

How to hide formulas in Excel Picture 2 How to hide formulas in Excel Picture 2

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.

How to hide formulas in Excel Picture 3 How to hide formulas in Excel Picture 3

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.

How to hide formulas in Excel Picture 4 How to hide formulas in Excel Picture 4

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.

How to hide formulas in Excel Picture 5 How to hide formulas in Excel Picture 5