• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Protect Cells

D

DaveNJ0124

New Member
In Excel 2003, how do I protect various cells in a worksheet? I don't want to protect the whole worksheet just various cells around the worksheet from having the cell info deleted/tampered?


Thanks,

Dave
 
right click on cells, go to format cells. go to protection. Any cells you DON'T want to protect should have the "Locked" cells UNCHECKED.
 
Dave,


Welcome to Chandoo_Org Forums.


By default all cells have the Locked Property enabled.


Please select the cells where you want the end user to be able to enter data.

Right click and select Format Cells (or CTRL+1 keyboard)


Click on the Protection Tab


Remove the check mark from Locked

Click on Ok.


Now protect your entire sheet.


Post this you will only be able to enter data in the cells where Locked was unchecked, all other cells will not allow any data entry.


~VijaySharma
 
Each cell has a protection setting called "locked" that you can toggle to indicate whether you want the contents protect when worksheet protection is activated. For your case, I'd recommend selecting the whole sheet, unlock all the cells, then go back and change the few cells that you want protected to locked status.


Where's the status at?

Format cells - Protection, Locked


After you've got the cell settings setup, protect the workseet (Tools - Protection, Protect worksheet)
 
You must log in or register to reply here.
Back
Top