Protecting a certain cell in Excel

  • Thread starter Thread starter Tdinova
  • Start date Start date
T

Tdinova

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
 
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.

Format>Cells>Protection. Uncheck "locked" and OK out.

Now select those formula cells and Format>Cells>Protection. Check "locked".
Ok out.

Now Tools>Protection>Protect Sheet.

Tip: Tools>Customize>Commands>Format. 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
 
Say that works great

Thanks

Gord Dibben said:
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.

Format>Cells>Protection. Uncheck "locked" and OK out.

Now select those formula cells and Format>Cells>Protection. Check "locked".
Ok out.

Now Tools>Protection>Protect Sheet.

Tip: Tools>Customize>Commands>Format. 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
Click to expand...
 
Back
Top