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. |
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