Instructions for hiding formulas in Excel

You must work regularly with excel spreadsheets, your work requires high security. You do not want anyone to know the calculation formulas in Excel spreadsheets, you simply want others to manipulate the results do not want them to know the details of how to calculate the results. Today's article helps you solve that problem by hiding the formula and only displaying the simple results.

The example here wants to hide the formula in the cash register.

Instructions for hiding formulas in Excel Picture 1

Step 1: Highlight the whole workbook-> right click -> Format Cells .

Instructions for hiding formulas in Excel Picture 2

Step 2: The dialog box appears, select the Protection tab -> uncheck the Loked and Hidden items -> OK .

Instructions for hiding formulas in Excel Picture 3

Step 3: Select cells that contain formulas to hide. For example, here select the values ​​in the column of money. Right-click -> Format Cells .

Instructions for hiding formulas in Excel Picture 4

Step 4: Select the Protection tab -> select Loked and Hidden -> OK .

Instructions for hiding formulas in Excel Picture 5

Step 5: After making your selection, move the REVIEW tab -> click Protect Sheet .

Instructions for hiding formulas in Excel Picture 6

Step 6: A dialog box appears to enter a password to protect the formula.

Instructions for hiding formulas in Excel Picture 7

Step 7: Enter the password again -> OK .

Instructions for hiding formulas in Excel Picture 8

Back to the excel sheet -> click the values ​​in the column of money, you observe only the results do not show the formula.

Instructions for hiding formulas in Excel Picture 9

In some cases you want to open edit, change the formula you do as follows:

Go to REVIEW tab -> Unprotection Sheet .

Instructions for hiding formulas in Excel Picture 10

The dialog box appears enter the password -> click OK .

Instructions for hiding formulas in Excel Picture 11

The results of the formula have shown you arbitrary editing, if you want to hide the formula, do the same operation as above.

Instructions for hiding formulas in Excel Picture 12

Above is how to hide formulas in excel hoping to help you protect your data.

Good luck!