Hide Formulas

[nanda_kishore]

I want to hide the formula in a cell, what ever formula I include in a cell, it should display only the value and not the formula itself. Is it possible in excel ?

 

[c_m]

nanda_kishore,
Welcome to the Board.

Try:
right click on cell>>select Format Cells>>go to Protection tab>>Check Hidden>>Click ok>>Then protect your sheet.
By doing this, your formula will be hidden but the calculated value will still be visible.

 

[joy_666]

Protect the sheet..... usimg the format option

 

[PRIMA]

Hi c m,

Is there a way not protect the sheet? Because, if you will protect your sheet you cannot make any changes in the value or nobody can access your sheet of file.

Your input is highly appreciated.

Thanks.

Prima

 

[joy_666]

Hi Prima,

You can protect the sheet and specify the columns to be protected.....

 

[c_m]

As far as I know, I dont think there is another way of hiding formula. If you are concerned about nobody able to make any changes, you can select the cells that you want users to be able to change and uncheck "Locked" from protection tab.

Another way would be to use VBA. Some sort of code that will replace the formula its value. I wouldnt prefer this because then when you change your precedents, the value where you had your formula wont update (or you atleast have to type the formula again). Does that make sense?

 

[nanda_kishore]

well, I want the formula to remain in the cell,but it should not be visible. Let me try protecting the sheet.

 

[nanda_kishore]

this works man !!!! it served my purpose.. thanx a lot !

 

[nanda_kishore]

Try:
right click on cell>>select Format Cells>>go to Protection tab>>Check Hidden>>Click ok>>Then protect your sheet.
By doing this, your formula will be hidden but the calculated value will still be visible.


this one worked for me !<!-- / message -->