Hidding formulars used in a worksheet

  • Thread starter Worksheet Formulars
  • Start date
W

Worksheet Formulars

I don't want the formular I used in the worksheet to display on the formular
bar. How do I do this?
 
M

Mike H

One way,

Select all the cells in your worksheet by clicking in the small grey box to
the left of column A. The click Format - Cells - Protection and remove the
locked checkmark.

Now select your cells with formula in and click Format - Cells - Protection
and check the hidden box. Protect the worksheet and your formula are now
hidden.

Mike
 
Top