Easily qualify user editable regions in the WPS2009 table

In the daily work there are always some complex WPS forms need to be edited to complete, such as a project in the general table will be through the financial, project, quality three departments of people to proofread and modify the final decision. In this context, we need to try to limit the ability of everyone to edit only the WPS cells within their own work rights, not to modify other cell contents.

This effect can be easily achieved by setting the editing area in a wps table in the WPS Office 2009-person edition.

Set edit area and password

Open the Designed worksheet with the WPS table, click Tools on the menu bar, select Protect/Allow user edit area, and open the Allow users to edit the range window (Figure 1).

Computer Tutorials

Click the New button, and in the new zone window that pops up, enter the title "Finance," and drag to select the contents of the Reference Cells entry box. Then directly in the worksheet, select the area (H4:I60,L4:L60) that the financial staff can edit, and hold down the CTRL key to select multiple nonadjacent areas, and the number of the selected area will automatically appear in reference cells, but you can also enter the reference cell number directly.

When you select a range of cells, then enter "Zone password", for example: 123456, click the OK button (Figure 2), repeat the password in the pop-up window, and click OK to add a "finance" item to the list of areas in the Allow users to edit the range window.

Repeatedly click the New button to set the region password operation, a new project, quality security and other people's editing area, and set up a different "zone password." For areas where the error is set, click the Modify button in the Allow users to edit range window to select the item to reset. When all the settings are complete, click the Protect Sheet button in the Allow users to edit the range window, and in the Protection sheet window that opens, enter a total password to use when you edit it (Figure 3).

Edit by Password

Now you can send a set of worksheets to everyone to proofread changes, you only have to separate each area password to them, you can enter their own password to edit their own area.

Financially, when he selects any cell in the financial area to enter, a window that asks for a password is popped up, entering the provided financial area password 123456, which can be used to modify the data freely in all cells in the financial area.

If he chooses another area to modify, the password cannot be edited because it cannot be entered correctly. The password is entered only once, and then the other cells in the financial area are not prompted for the password, and are prompted again only when you exit the edit for this document. In addition, the region password can only delete, modify, input cell data, can not modify any format, so do not worry about the format of the table will be randomly changed.

Note: When you set the zone permissions, the selected areas can overlap. In this case, the "fine" part should allow accounting and quality personnel to modify, so in the establishment of accounting, quality security editing area should be selected in the area of the penalty. This allows you to edit the financial or quality password in the password window when editing the penalty area.

After file recycling, you simply click "Tools" in the menu bar, select "Protect → unprotect sheet", and enter your total password to make sure you are free to edit after you remove the protection. Of course, simply by setting cell protection can also achieve the same effect, but it must be for everyone to customize a dedicated document, it will be more trouble, and not conducive to continuous and simultaneous editing.