Hide a formula. Change Source data
 

I would like to hide a formula and be able to edit the data that feeds into
the formula. When I protect and hide the formula, the data cells can not be
changed either. Help would be much appreciated.

Hide a formula. Change Source data
 

By default, all cells are locked, so that when you protect the
worksheet, all cells are not editable. To get around this, select all
the cells in the worksheet (click the button above the "1" row header
and to the left of the "A" column header), uncheck the Protected item
on the Format Cells dialog. Then, go back and choose the cells that
really should be locked, set the protected status, and protect the
sheet.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Mon, 15 Feb 2010 12:23:01 -0800, wheelspk
wrote:

I would like to hide a formula and be able to edit the data that feeds into
the formula. When I protect and hide the formula, the data cells can not be
changed either. Help would be much appreciated.

Hide a formula. Change Source data
 

Can you post your formula?

"wheelspk" wrote:

I would like to hide a formula and be able to edit the data that feeds into
the formula. When I protect and hide the formula, the data cells can not be
changed either. Help would be much appreciated.