how to protect one cell and not others

C

Cyrus

Is there a way to protect one cell or a range of cells without protecting the
entire worksheet? For example, enter data, but formulas are untouched.

Thanks,

Cyrus Walker
 
S

SteveG

Cyrus,

You can unlock all of the cells in the worksheet. Then select th
range you wish users not to be able to edit and lock those cells only.
Then when you protect your sheet, only the cells in your range will b
protected. You can customize the options as to what users can edi
when you protect the sheet.

Select all the cells in the sheet. Right mouse click, Forma
Cells/Protection. Deselect the Locked option.

Select your range of cells you want protected. Format Cells/Protectio
and re-select the Locked option.

Protect your sheet and set what you want your users to be able t
edit.

Cheers,

Stev
 
Top