New excel spreed sheet

I got some great help yesterday with my new spreadsheet but I have just 1 more question. I need to lock down my sheet apart from the cells that I need people to enter data which is about 10 cells in different parts of the sheet. Is there a way to do this. Thank you.
jodyreidIT ManagerAsked:
Who is Participating?
 
Brad GrouxConnect With a Mentor Senior Manager (Wintel Engineering)Commented:
Yes, you can do this. The order is kind of strange but you can do it.

Lock the worksheet entirely (Tools > Protection > Protect Sheet), then select the cells/columns/rows that you want to allow people to edit and use "Format Cells" and uncheck the "Locked" option.

NOTE: You may need to uncheck the "Locked" option first and then lock the worksheet.
0
 
pony10usCommented:
Brad is correct. In my experience I have always had to unlock the cells first then lock the spreadsheet.

Remember that if you don't want the users to be able to just unlock the spreadsheet then you need to password protect.
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.