Hidding formulars used in a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't want the formular I used in the worksheet to display on the formular
bar. How do I do this?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMULAR REDIRECT 4
paste without formular 1
Conditional Formating 1
Cell formular 2
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3
VLOOKUP FORMULA 1
Excluding "0" in standard deviations 4
I need serious help Worksheet functions 4

Back
Top