Formulas

  • Thread starter Thread starter Derf
  • Start date Start date
D

Derf

I created a worksheet for work and input a formula to add up several
different cells for us and I would like to know if there is a way to protect
just the formula but still let other people be able to change the numbers as
they change three different times per shift for three shifts.
 
Hi

all cells in a sheet have their Format>Protection property set to Locked by
default.
As soon as you apply Tools>Protection>protect sheet the cells will be
protected.

All you need to do is format the cells where you want Data entry to take
place to be not locked (remove check mark from Locked), then apply sheet
Protection.
 
By default, the cells in a worksheet are set as "Locked", but this
does not become active until you protect the sheet. However, as you
only want to protect one cell, it would be better to unlock all cells
and then lock the cell with your formula in.

Click on the grey square at the intersection of the row and column
identifiers (which will highlight all cells in the worksheet), then
click on Format | Cells | Protection tab, then uncheck Locked and
Hidden and click OK. Then click on the cell with your formula in and
Format | Cells | Protection tab, then check Locked (and maybe Hidden,
depending on whether you want your employees to see the formula), then
OK.

Then click on Tools | Protection | Protect Sheet and check the options
you require - the password is optional, but if you give one then you
will be asked to repeat it (make a note of it, as well). Now you will
be able to type in any cell except for the one containing your
formula.

Password protection is not very secure in Excel, but it will probably
suffice in this instance.

Hope this helps.

Pete
 
Back
Top