LOCK columns
 

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

Have you considered looking in HELP index for protection?

--
Don Guillett
SalesAid Software

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

Rebecca

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

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.

Now ToolsProtectionProtect Sheet.


Gord Dibben Excel MVP

On Fri, 25 Feb 2005 17:39:03 -0800, "Rebecca"
wrote:

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