protection

[imported_unknown]

Hi! I have created a spreadsheet in Excel. I am trying to protect some cells while leaving others open so that employees may enter information. I have tried the help menu about selecting cell, choosing lock/unlock, protect sheet and all that jazz, but is still doesn't work. If you could help, I would appreciate it. Thanks!

Scott

 

[Brian from Maui]

After locking the cells, you need to go to Tool/Protect/Protect Worksheet

 

[nick m]

What you will need to do is right click on the cell you want to enter data in. goto properties / protection then uncheck the lock box and check the hidden, when you protect your sheet you will be able to input in these cells only.

Good luck

 

[imported_unknown]

Worked perfectly. Thanks!

Scott