Breaking News
Loading...
Wednesday 20 May 2009

Info Post
Such a nice feature. I somehow missed it!

How to prevent a formula from displaying in the formula bar.
Caution - This procedure also prevents the cells that contain the formula from being edited.
  1. Select the range of cells whose formulas you want to hide.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box. Click OK.
  4. On the Tools menu, point to Protection and then click Protect Sheet.
  5. Make sure the Protect worksheet and contents of locked cells check box is selected.

0 comments:

Post a Comment