ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I lock unclock cells to protect the data entered? (https://www.excelbanter.com/excel-worksheet-functions/134548-how-do-i-lock-unclock-cells-protect-data-entered.html)

Sandi@hotmail

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.

Joerg

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.





All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com