How Excel worksheets set different editing permissions

how Excel worksheets set different editing permissions

There is such a business table, by the different sections of the staff to fill out separately.

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":