Allow Cell Entry In Some Cells On Protected Worksheet

  • I know that there is a lot on locking cells but it is confusing to me. I am able to lock a worksheet but that is not what I need. I have an Excel document that has thirty to thiry-six names on it. I do not want anyone able to edit the names. But I do want them to be able to add a name.


    Example:


    There are 30 students in the classroom. A new student comes in. I want the teacher to be able to add that student to the roster but not able to edit the names above. What do I need to do?

  • Re: Locking A Range Of Cells


    • Unprotect the workbook
    • Unlock all cells
    • Select the cells that have the existing names
    • Lock those cells
    • Protect the workbook

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]