protect specific cell but allow edit on other cell

C

chiuinggum

How can I protect specific cells but allow editing on other cells. Once the
cell is edited the file can be saved.
 
G

Gord Dibben

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP
 
C

chiuinggum

but by sheet protection the files could not be saved unless they know the
password. i want only specific cell to be locked preventing alteration but
still allow other cells to be edited and file save.
 
G

Gord Dibben

You can still save a workbook that has sheet protection enabled.

No need for anyone to know a password.

Did you try the method I posted or just reject it because you don't understand
the process?


Gord
 
C

chiuinggum

i got it done. thanks. guess i was too rush

Gord Dibben said:
You can still save a workbook that has sheet protection enabled.

No need for anyone to know a password.

Did you try the method I posted or just reject it because you don't understand
the process?


Gord
Click to expand...
 
Top