Protecting cells

R

rob p

Excel 2000. I have a worksheet that has some columns I want protected and
some others I want to be able to enter / edit . How do I set this up. (I
don't want to protect ALL of the worksheet.)

Thanks...
rob
 
J

JulieD

Hi rob

protection in excel works by first choosing the cells that you don't want
protected (select cells; fomat / cells - protection tab; untick locked) and
then protecting the worksheet (tools / protection / protect sheet).

cheers
julieD
 
A

Andy B

Hi

All cells are locked by default. This means that if you protect your
worksheet, al cells will be locked. What you need to do is unlock the cells
that you want access to and then protect your worksheet, to enable this
locking. To unlock the cells you want to be able to type in, right click on
them (or whole rows/columns) and on the Protection tab uncheck the Locked
flag.
Once you've done all of the ones you need, protect the sheet wth Tools /
Protection.
 
C

Charlie O'Neill

Rob,

Highlight all the cells you want to be able to enter data in, on the menu
bar choose Format/Cells/Protection. Then remove the check in locked.

Charlie O'Neill
 
K

kkknie

The default for a cell is locked, so if you protect the sheet, all cell
will be locked. To unlock the ones you want to allow entry:

1. Select the cells you want unprotected.
2. Click the Format menu item and select Cells
3. Click the protection tab and uncheck the locked checkbox.
4. Click the Tool menu item and select Protect Sheet.
5. Choose to enter a password or not.
 
R

rob p

Julie / Andy:
Thanks to both of you for such a quick response. Answered my question.
Rob
 
J

jeff

Hi, Rob,

You can allow users access to certain cells but keep then
from others easily. Select the cells you will allow them
access, then Menu-Format-Cells-Protection tab - uncheck
"Locked" & Ok; then protect your worksheet. (here, you
can even select certain attributes for added flexibility)

All cells NOT selected by you will be locked.

jeff
 
Top