C Cindy Conover Jan 30, 2009 #1 Is there a way in Excel 2002 SP3 to protect certain columns so employees do not mess up and formulas? TIA Cindy
Is there a way in Excel 2002 SP3 to protect certain columns so employees do not mess up and formulas? TIA Cindy
G Gord Dibben Jan 30, 2009 #2 By default all cells in a worksheet are locked when sheet protection is enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. Format>Cells>Protection is where you would change the "locked" or "unlocked" status. Select all cells and unlock them. Select the cells to be locked and lock them Then Tools>Protect>Protect Sheet. Note the selectable options under "allow users to" when protecting. Gord Dibben MS Excel MVP
By default all cells in a worksheet are locked when sheet protection is enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. Format>Cells>Protection is where you would change the "locked" or "unlocked" status. Select all cells and unlock them. Select the cells to be locked and lock them Then Tools>Protect>Protect Sheet. Note the selectable options under "allow users to" when protecting. Gord Dibben MS Excel MVP
C Cindy Conover Jan 30, 2009 #3 Wonderful. I know there was a way but I could not figure it out. Thanks so Much Cindy
