Protecting formulas in cells

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I need to know how to protect only the cells that have a
formula in them, and still allow editing of other cells.
How.
 
You can select special ranges by:
ctrl-A to select the whole sheet
Edit|goto|Special
click on Formulas (or constants or blanks)

Now you've just selected all the formulas (or constants or blanks).

Format|Cells|Protection Tab
Check Locked or uncheck Locked (depending on what you selected)

Now protect the worksheet. Tools|Protection|protect sheet.

====
Depending on how many cells I want different, I'll select everything and unlock
them. Then come back and lock just the formulas.

(was this as confusing as I think???)
 
From the help files:

By default all cells on a worksheet are locked. Before you protect a
worksheet, you can unlock cells where you want users to enter and change
data, in two ways. To unlock cells for all users, you can use the Protection
tab of the Format Cells dialog box. To unlock cells for specific users, you
can use the Allow Users to Edit Ranges dialog box. Any ranges that you
specify in this dialog box and don't assign a password for are also unlocked
for all users. The cells you leave locked become protected only after you
protect the worksheet.
 
Back
Top