Only Lock Certain Cells

Delta Star

Board Regular
Joined
Oct 28, 2009
Messages
184
Probably something easy but I don't seem to be able to figure it out.

I have a worksheet that I would like certain cells to be locked so that the formulas cannot be changed. However some cells will need to be unlocked so that the user can input data.

How would I do this?

I'm using excel 2003 if that makes any difference.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Select the cells that you want to be changeable, Format > Cells > Protection tab, untick Locked and click OK. Then protect the sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,805
Messages
5,524,979
Members
409,613
Latest member
Dalex100

This Week's Hot Topics

Top