Excel table data partition password how to set

Everyone in the use of office2010 to make Excel tables do not know how to set the Excel table data partition password, in fact, the method is very simple oh, as long as the Office2010excel table in the new area and then select the partition can be set up the password Oh, Let's take a look at the following with small knitting.

office2010 set the Excel table data partition password method:

The first step: first open the office2010 Excel table, enter the data.

Step Two: Click the Review on the main menu and click Allow Users to edit the area.

Step three: Click on the new area, select the selected area, and set the password 123 (the password is set casually, but must remember). Then enter the password again, so the first area password is set.

Fourth step: Do the same, create a second zone password 1234. You can also set a third fourth password. Depending on your request.

_#office2010 How to set the Excel table data partition password 2#_

Fifth step: Click on the protection worksheet, set the worksheet password, this password must be set, otherwise the previous settings are invalid.

Sixth step: Finally, we can see, set editable area, as long as the input password can be edited, non-editable area, you must remove the worksheet protection. Well, the whole process has been said, everyone to explore their own, should soon be.