HOW TO HIDE FORMULA

  • Thread starter Thread starter Deepak J
  • Start date Start date
D

Deepak J

Hi everyone,

how can i hide formula so that no other can see how have i reached to
certain number except me. but still formula wll be working in background.

thanx
 
Hi!

You can use protection for this.
1. First select the cells where you want the users to enter/change values,
then select "Cells" from Format menu
On the Protection tab, unselect "Locked" and click OK.
2. Then select the cells where you have the formulas you want to hide and
again select "Cells" from the Format menu
On the Protection tab, check "Locked" and "Hidden", then click OK.
3. Now you have to activate the protection, select Protection from the Tools
menu and then "Protect sheet", enter a password and click OK.
Now the users can't see or change the formulas that you wrote, but they can
enter values in the cells you selected in step 1.

Best regards

Stefan Hägglund
Microsoft.

If you select the cells where you have the formulas and then
 
Back
Top