Hide the formula

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

Hi,

How can i hide the formula in some cell and keep some cells free, so that we
can the enter the data.

Friend in need...

Mat
 
Format|Cells|Protection tab:

If hidden is checked, it will hide the contents of the cell (i.e.: the
formula), when the sheet is protected.
If Locked is unchecked, it will allow the person to enter data intot he cell
when the sheet is protected.
 
Hi,

Thanx John.

Mat

John C said:
Format|Cells|Protection tab:

If hidden is checked, it will hide the contents of the cell (i.e.: the
formula), when the sheet is protected.
If Locked is unchecked, it will allow the person to enter data intot he cell
when the sheet is protected.
Click to expand...
 

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

Hiding data using a formula 2
Hide divo error 4
invisible formula in formula bar 1
Hide Formulas 1
Excel EXCEL - using a date dependant formula to hide rows 3
Hide Formula 7
How can I hide a formula in Excel 2007 from other users seeing it 3
Hiding Formulas in Formula bar 3

Back
Top