Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock unclock cells to protect the data entered?
I would like help with Excel in Office system 2007.
How d I lock and unlock cells? I am looking for cell protection for the data I've enterd. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I lock unclock cells to protect the data entered?
How about consulting the Excel Help file? Quote:
"By default all cells on a worksheet are locked. Before you protect a worksheet, you can unlock cells where you want users to enter and change data, in two ways. To unlock cells for all users, you can use the Protection tab of the Format Cells dialog box. To unlock cells for specific users, you can use the Allow Users to Edit Ranges dialog box. Any ranges that you specify in this dialog box and don't assign a password for are also unlocked for all users. The cells you leave locked become protected only after you protect the worksheet." Cheers, Joerg "Sandi@hotmail" wrote in message ... I would like help with Excel in Office system 2007. How d I lock and unlock cells? I am looking for cell protection for the data I've enterd. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock/protect cells so they can't be changed | Excel Worksheet Functions | |||
Lock Data in Cell after entered | Excel Discussion (Misc queries) | |||
How do I lock a cell automatically after it has data entered. | Excel Discussion (Misc queries) | |||
Protect data in cells after entered | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) |