MS Excell cell protectect

I am the only user of my spreadsheets. Sometimes I would like to protect a few cells that almost never change so I don't modify them by accident.

Is there a quick way to protect a few select cells?

Thanks
Ronnie KaufmanRenewal TeacherAsked:
Who is Participating?
 
gtglonerConnect With a Mentor Commented:
Select all cells, right click and select Protection tab. Unselect the "Locked" checkbox and click OK. Select the cells you want protected and click Tools-Protection-Protect Sheet. Unselect "Select Locked Cells" checkbox and click OK.
0
 
jppintoConnect With a Mentor Commented:
By default, if you right click on any cell and check Format Cells-Protection, you will see that all are marked as "Protected". You need to uncheck this propertie on the cells that you want to write and then protect the sheet on Review-Protect Sheet so that the locking works.

jppinto
0
 
jppintoConnect With a Mentor Commented:
Here's a simple article about this:

http://support.microsoft.com/kb/214081

jppinto
0
 
Ronnie KaufmanRenewal TeacherAuthor Commented:
Thanks to the 3 answers I got ...they each were goo ... and easy.

Much appreciate the very quick response.

Makes the Expert Exchange service worthwhile to belong to.

rk
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.