Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting certain cells
I am using formulas to get averages , standard deviation and other
figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated -- |
#2
|
|||
|
|||
In Excel, cells are either locked or unlocked; the default is locked. If a worksheet
is not protected, there is no difference in behavior, but if you protect the worksheet, the locked cells are protected, but the unlocked cells can be edited. What you need to do is unlock all cells except for the ones you want to protect, then protect the workbook. Don't bother with a password, unless the users are really dense. The warning will be a simple reminder that there's a formula you don't want to break. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tdinova wrote: I am using formulas to get averages , standard deviation and other figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
Excel Charts and cells | Charts and Charting in Excel |