Protecting a certain cell in Excel
 

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

Hi

to enable worksheet protection you need to
- choose all the cells that you want to be able to change

- choose format / cell / protection - untick "locked", click OK

- choose tools / protection / protect sheet ... OK

now you can change the cells you selected in step 1, but can't change the
"locked" cells.

Hope this helps

julieD



"Tdinova" wrote in message
news:2mstd.1181$6f6.863@edtnps89...

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

You can select which cells to lock and then enable worksheet protection.

By default all cells on a sheet are locked when sheet protection is enabled.

Hit CRTL + A(twice for 2003 users) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK out.

Now select those formula cells and FormatCellsProtection. Check "locked".
Ok out.

Now ToolsProtectionProtect Sheet.

Tip: ToolsCustomizeCommandsFormat. Scroll down to the Padlock(lock cells)
icon.

Drag to your Toolbar.

Saves a few steps when selecting cells to be locked/unlocked.

Gord Dibben Excel MVP


On Wed, 08 Dec 2004 00:59:42 GMT, "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

Say that works great

Thanks

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You can select which cells to lock and then enable worksheet protection.

By default all cells on a sheet are locked when sheet protection is
enabled.

Hit CRTL + A(twice for 2003 users) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK out.

Now select those formula cells and FormatCellsProtection. Check
"locked".
Ok out.

Now ToolsProtectionProtect Sheet.

Tip: ToolsCustomizeCommandsFormat. Scroll down to the Padlock(lock
cells)
icon.

Drag to your Toolbar.

Saves a few steps when selecting cells to be locked/unlocked.

Gord Dibben Excel MVP


On Wed, 08 Dec 2004 00:59:42 GMT, "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