Excel security settings for row and column and worksheet protection

Hide data

1. How to hide sensitive data in a data table? Hide all the artist names. As shown in the following figure.

First, take a look at the effect chart and the operation steps.

2. The key of this method is to enter (;) in the custom type. Be sure to enter a semicolon using the English input method.

3. Careful friends found that the data is not completely hidden, and I can completely hide it by protecting the worksheet. To show data, you only need to unprotect the worksheet. The effect is as follows. Tools-protect worksheets (high security)

 
Set protection worksheet

1. After hiding the data, I set protection for the worksheet and found that other data modifications or inputs are restricted.

2. to solve the problem above, you can cancel the lock cell operation and repeat the operation above, the effect is good, you can either hide data or input or modify other data. Very practical Excel security settings.

Set editable work areas

1. Flexible use of Excel security settings, a Golden Bell for data tables. Only cells in the target region must be edited. Cells outside the target region cannot be edited. Operation process: first lock all cells in the table, then unlock the cells in the editing area, and finally set to protect the worksheet and set the password.

2. Cells except the target area cannot be edited. (You can only edit the target area that has been set to unlock the cell protection, as in the red rectangle of the graph)

Set and edit the work zone password

1. On the basis of usage 2, we set password protection for the target editing area, which will make the data more secure.

First, select all the cell formats to protect the lock. The tool-protect-allows users to edit the area.

A password is required to edit data in the target region. Data cannot be edited outside the target region. A prompt is displayed as shown in the following figure.