In creating a spreadsheet how can I lock a formula cell only?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a spreadsheet in Excell and want to lock the formula
cells to they cannot be typed over accidently destroying the function??
 
Bob

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

On Tue, 20 Sep 2005 16:07:01 -0700, "Frozen Bob" <Frozen
 
Hi Bob

Choose Tools>Protection>Protect Sheet - you can use a password or leave it
blank. (If you do use a password, write it down to remember it!!).
Protecting a sheet mean cells which are locked cannot be overwritten.

Cells are Locked as the Default setting.

Before you protect the sheet, select the cells which you require the user to
enter data and Format>Cells>Protection and remove the tick from Locked.

Passwords in Excel are not totally secure. They will deter the in
experienced user, but there are plenty of readily available password
crackers available for those who wish to break them.


Regards

Roger Govier
 
Back
Top