How do I restrict the editing area of each department in an Excel table?

How do I restrict the editing area of each department in an Excel table?

1, open the Excel work form, the following table as an example, the results of various subjects need to be completed by the scores of teachers. The editors will be limited to Chinese, maths and English respectively.

2, select Review in the toolbar-allows users to edit the area. In the Allow users to edit the Region dialog box, select New.

3, in the New Area dialog box to set, title writing language, reference cell area is the language teacher to edit the area, click on the right side of the square icon, manually select the area. Region password set, the password is in the Language teacher editor will be used, each section set different password.

4, using the same method, new math, English, allow editing areas. The completed area appears in the dialog box, and when you're done, click on the Protect sheet.

5, step out of the Protection Worksheet dialog box, set the password, check selected locked cells, selected unlocked cells. Are you sure.

6, after the completion of the above steps, the three subjects to limit the user editor completed. If you need to edit your language scores, you need to enter a password that you previously set to complete.