How do I lock unclock cells to protect the data entered?

G

Guest

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

Joerg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top