LOCK columns

R

Rebecca

Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent
accidental changes to the data? Thanks.
 
G

Gord Dibben

Rebecca

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.


Gord Dibben Excel MVP
 
Top