G Guest Feb 26, 2005 #1 Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent accidental changes to the data? Thanks.
Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent accidental changes to the data? Thanks.
G Gord Dibben Feb 26, 2005 #3 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
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
