The table cannot be edited because the protected mode is set. The solution: 1. Open a table on the desktop; 2. Find the "Review" tool on the table and click it; 3. Find and click "Unprotect the worksheet" to resume editing.
The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel 2016, Dell G3 computer.
Why can’t the table be edited?
The Excel table is set in protected mode. You just need to turn off the protected mode.
1. First open a form on the desktop.
#2. After opening it, find the review tool on the form and click it.
#3. After opening the review, you will see an unprotected worksheet inside, click on it.
#4. You will need to enter a password before canceling. After entering, click OK.
#5. After confirmation, the protection mode of the Excel table will be cancelled, so that it can be edited.
Related learning recommendations: excel tutorial
The above is the detailed content of Why can't the table be edited?. For more information, please follow other related articles on the PHP Chinese website!