Hide Formula in Excel

Sometime there will be a situation where you have created some clever formula and you don’t want to disclose it.

Is it possible to hide formula and display the results?

Yes it is possible, by using below steps

1)  Create Excel File

2)  Write one number cell B1

3)  Write another number in cell B2

4)  Create Sum formula in Cell B3 (=B1+B2)

5)  Right Click on B3

6)  Click on Format cells

7)  Click on Protection Tab

8)  Select Locked and Hidden Check Box

9)  Select Review Tab. Select the option protect sheet

      10) System will ask for password, provide your password  and click Ok.

11) Then Re Enter same password again.

12) Now you will see that formula bar will not show the formula

If you want to edit the formula then unprotect the sheet and do the needful

Keep Learning

Sanjay Bakshi

mesanjaybakshi@gmail.com