how do I hide a cell formula from the formula bar

[S. Shah]

I want to enter a formula in a cell - but dont want it to appear in the
formula bar.
Please let me know - how to go about it. Thanks.

 

[Mike H]

Hi,

It takes a few steps so instead of me explaining have a look here

http://www.techonthenet.com/excel/cells/hide_formulas.php

Mike

 

[Gord Dibben]

Format>Cell>Protection>Unlock the cell and enable Hidden

Tools>Options>Protect Sheet................sheet MUST be protected


Gord Dibben MS Excel MVP

On Sat, 6 Dec 2008 13:40:00 -0800, S. Shah <S.