How to cancel the locked state of the table in wps excel How to cancel the locked state of excel

Using the wps excel table tool, you can perform data entry, editing and statistics operations. When you edit a lot of important data in wps excel, the table will be locked to prevent it from being accidentally modified, but the locked cells How to unlock it? The editor will introduce the solution method below. Method step 1. First enter the operation interface of WPS Excel. When you need to modify the content, you will find that you cannot modify it and you will be prompted that the content does not support this function. This is because the worksheet is locked.

2. For this, you can position the mouse to click on the [Review] tab, and then click the [Undo Worksheet Protection] option in the function options that appear.

3. Then, in the window that opens to unprotect the worksheet, enter the password you previously set to lock in the box, and then click the OK button.

4. Now if you look at the function options just now, there is no longer a function to unprotect the worksheet, and the lock cell function is also displayed normally.

5. Subsequently, you can edit and modify the data content on the page, and then it will be edited normally, as shown in the picture.

The above is the detailed content of How to cancel the locked state of the table in wps excel How to cancel the locked state of excel. For more information, please follow other related articles on the PHP Chinese website!