Excel 2000 hiding formulas

[foilprint0]

I have created a workbook that I have hidden rows and locked cells what I wanted to know is:-
Is there a way of hiding the formula in a cell?

Cheers for any help

 

[Zack Barresse]

you could always take out the formula bar. tools -> options -> view (i think), uncheck formula bar.

HTH

 

[foilprint0]

When the user opens up the spreedsheet they can turn the formula bar back on though!

 

[Iridium]

Selct the cells who's formulae you want to hide then go to Format>Cells - Protection tab and check the 'Hidden' option. Then protect the sheet via Tools>Protection>Protect Sheet...

HTH