Hide a formula. Change Source data

  • Thread starter Thread starter wheelspk
  • Start date Start date
W

wheelspk

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.
 
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]
 
Back
Top