F ForSale Oct 27, 2004 #1 This is a dorky question, but what is the best way to lock formulas fro being changed? i'm on excel 2002 thanks
This is a dorky question, but what is the best way to lock formulas fro being changed? i'm on excel 2002 thanks
G Gord Dibben Oct 27, 2004 #2 You can select which cells to lock and then enable worksheet protection. By default all cells on a sheet are locked when sheet protection is enabled. Hit CRTL + A(twice for 2003 users) to select all cells. Format>Cells>Protection. Uncheck "locked" and OK out. Now select those formula cells and Format>Cells>Protection. Check "locked". Ok out. Now Tools>Protection>Protect Sheet. Tip: Tools>Customize>Format. Scroll down to the Padlock(lock cells) icon. Drag to your Toolbar. Saves a few steps when selecting cells to be locked. Gord Dibben Excel MVP
You can select which cells to lock and then enable worksheet protection. By default all cells on a sheet are locked when sheet protection is enabled. Hit CRTL + A(twice for 2003 users) to select all cells. Format>Cells>Protection. Uncheck "locked" and OK out. Now select those formula cells and Format>Cells>Protection. Check "locked". Ok out. Now Tools>Protection>Protect Sheet. Tip: Tools>Customize>Format. Scroll down to the Padlock(lock cells) icon. Drag to your Toolbar. Saves a few steps when selecting cells to be locked. Gord Dibben Excel MVP
