excel2007 have a lot of work in the book, how to set up bulk to protect workers and to lift …

not only click the “format” menu “cell”, click “protect” tab , And then remove the “lock” check box; then repeated to do.In the default mode, all the cells are locked in a state, which means that as long as you keep working, all the cells no longer have to be revised.But
practice, we need to allow users to import content of the cells should be compared only, so only have to select those cells, the solution to lock out the signs on the line.
If you want to lift a few lines, Or out of certain election to select a few lines of it, “the cell formatting” to remove the lock symbol on the line
If you want to lift the whole table of the cell lock, the first need to select the entire table ( A is in the top of the left side of a place click) and then “set the cell format,” the lock
If you want to remove the signs to the lifting of a one-time thing working in the thin sheet of the target cell, it needs Over a period of VBA program to achieve.But I think this needs to be very little, if necessary, I can find.