ExcelBanter - Hide the formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hide the formula (https://www.excelbanter.com/excel-discussion-misc-queries/195986-hide-formula.html)

mat

Hide the formula

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

John C[_2_]

Hide the formula

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.
--
John C

"Mat" wrote:

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

mat

Hide the formula

Hi,

Thanx John.

Mat

"John C" wrote:

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.
--
John C

"Mat" wrote:

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

All times are GMT +1. The time now is 02:09 PM.