Protecting a certain cell in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tdinova - 08 Dec 2004 00:59 GMT

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 to this Message

JulieD - 08 Dec 2004 01:21 GMT

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

>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
[quoted text clipped - 4 lines]
>
> any help would be appreciated

Reply to this Message

Gord Dibben - 08 Dec 2004 01:32 GMT

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

>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
[quoted text clipped - 4 lines]
>
>any help would be appreciated

Reply to this Message

Tdinova - 08 Dec 2004 02:20 GMT

Say that works great

Thanks

> You can select which cells to lock and then enable worksheet protection.
>
[quoted text clipped - 26 lines]
> >
> >any help would be appreciated

Reply to this Message