How can we Hide Formula

[Ashu K]

Dear Seniors,

How can we hide a formula in excel sheet. Kindly help.

Regards

Ashu Kenith

[Ashish Kumar]

Dear Ashu,

Follow the steps for Hide Formula :

Select whole sheet with the help of CTRL + A

Go to the Format Cell With the help of CTRL + 1

Click on Protection Tab. & Un-check Locked and Hidden check box.

Press OK

Then after,

Select whole sheet (CTRL + A)

Go to the Format Cell (CTRL + 1)

Click on Hidden Check box and press OK.

Go to review Tab and click on protect sheet.

Putt your password.

Thanks

Ashish Kumar