Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting a certain cell in Excel
I am using formulas to get averages , standard deviation and other
figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated |
#2
|
|||
|
|||
Hi
to enable worksheet protection you need to - choose all the cells that you want to be able to change - choose format / cell / protection - untick "locked", click OK - choose tools / protection / protect sheet ... OK now you can change the cells you selected in step 1, but can't change the "locked" cells. Hope this helps julieD "Tdinova" wrote in message news:2mstd.1181$6f6.863@edtnps89... I am using formulas to get averages , standard deviation and other figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated |
#3
|
|||
|
|||
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. FormatCellsProtection. Uncheck "locked" and OK out. Now select those formula cells and FormatCellsProtection. Check "locked". Ok out. Now ToolsProtectionProtect Sheet. Tip: ToolsCustomizeCommandsFormat. Scroll down to the Padlock(lock cells) icon. Drag to your Toolbar. Saves a few steps when selecting cells to be locked/unlocked. Gord Dibben Excel MVP On Wed, 08 Dec 2004 00:59:42 GMT, "Tdinova" wrote: I am using formulas to get averages , standard deviation and other figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated |
#4
|
|||
|
|||
Say that works great
Thanks "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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. FormatCellsProtection. Uncheck "locked" and OK out. Now select those formula cells and FormatCellsProtection. Check "locked". Ok out. Now ToolsProtectionProtect Sheet. Tip: ToolsCustomizeCommandsFormat. Scroll down to the Padlock(lock cells) icon. Drag to your Toolbar. Saves a few steps when selecting cells to be locked/unlocked. Gord Dibben Excel MVP On Wed, 08 Dec 2004 00:59:42 GMT, "Tdinova" wrote: I am using formulas to get averages , standard deviation and other figurers... I want to be able to lock the cell so others cannot change my formula but be able to change certain values to get averages and other information .... I was trying to use the protection under tools to no hope... any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) |