Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock cell
how can i lock only one cell in my worskeet???
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock cell
Select all the cells
format|cells|protection tab|check unlocked select just the single cell you want locked format|cells|protection tab|check locked And for that locked cell to be treated as locked, you'll need to protect the worksheet: tools|protection|protect sheet (be aware that worksheet protection is easily broken--don't rely on this to protect your intellectual property.) teddi wrote: how can i lock only one cell in my worskeet??? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock cell
Select the whole sheet.
Format/ Cells/ Protection/ remove the tick mark from Locked. Select the cell you want to lock, same process but tick Locked. Tools/ Protection/ protect the worksheet. -- David Biddulph "teddi" wrote in message ... how can i lock only one cell in my worskeet??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock a cell | Excel Worksheet Functions | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
Cell Lock | Excel Worksheet Functions |