In this video, I demonstrate how to hide formulas in your worksheet. The 'hidden' attribute is a formatting attribute and can be applied on a cell by cell basis. Once hidden a formula will not appear in the formula bar.

The hidden attribute only comes into effect once sheet protection has been applied. If you want to be able to edit cells once worksheet protection has been applied, you will need to unlock cells.

Another method you can use for hiding formulas is to convert them to values. This way the answers to the formulas are visible on the worksheet but the formulas behind them are discarded.
------------------------