How Excel worksheets set different editing permissions

Have such a business table:

The item name and specification model of the table are entered by the storekeeper John on TA's computer;

Unit price, the amount by the buyer dick in TA's computer input;

Finally, from John to Dick to Wang Maizi, in the Wang Maizi computer to enter payment information, finished printing.

The purpose of the requirement is that each link can only enter information for the specified column, other data in the table is not editable, that is, read-only.

It is not difficult to achieve such a goal, let's take a look at the following specific steps:

Press CTRL + A to select all worksheets

and press CTRL + 1 to format the cells

Under the Protection tab, remove the "lock" and "Hide" tabs:

Select the area for which you want to set edit permissions

Set cell formatting by CTRL + 1

Under the Protection tab, select the Lock and hide check boxes:

Click Review to allow users to edit areas

Click the New button in the Allow User Edit Area dialog box that pops up:

In the New Zone dialog box, specify a title, an area to allow editing, and an edit password for the region, where we give John the password "1":

Repeat the steps above to specify the allowed editing area and edit password for dick and Wang Maizi, and the passwords for Dick and Wang Maizi are "2" and "3" respectively:

Finally click Review, protect sheet settings to protect the worksheet password (total password), this password should not be disclosed to others, once the worksheet protection is canceled, the protection of each edit area will be invalidated.

OK, set up, the different areas of the editor password to inform the corresponding operators can be:

Enter a password, and you can only edit the specified range, and other areas do not have permission to edit the changes.