What should I do if Excel cannot input directly into a cell? What should I do if Excel cannot input directly into a cell?

What should I do if Excel cannot directly enter cells? Excel is a table tool used by many users. Recently, many users have said that they are unable to input directly into cells during use. So what is going on? Let this site carefully introduce to users the solution to the problem that Excel cannot input directly into cells. Solution to the problem that Excel cannot input directly into cells. Method 1. In the first step, we first find a table document, then right-click the document, and then click to select the Excel option in the Open With mode.

2. In the second step, after entering the table document page, we select a cell on the page, then open the review tool in the toolbar, and then find the protection work in the sub-tool list Table option to see if the option appears to Revoke worksheet protection.

3. The third step, if it is because a password has been set, then we need to click the Unprotect Worksheet option, and then enter the password in the pop-up box to remove the protection.

4. The fourth step, some friends may worry that they accidentally protected the worksheet and forgot the password. In order to avoid this situation, we can click the triangle in the upper left corner of the table icon, select the entire table, then right-click to select the Format Cells option.

5. Step 5. After entering the format cell page, we click on the protection option, then uncheck the lock option on the protection page, and finally click OK.

Method 2

When using a form, it prompts that it is in read-only mode but text can be entered when saving. How to solve this problem? The content brought by PHP editor Strawberry today will answer this question in detail.

2. In the second step, after entering the properties page of the table document, we find the read-only option on the page, uncheck the option, and finally click Apply and Just confirm the option .

The above is the detailed content of What should I do if Excel cannot input directly into a cell? What should I do if Excel cannot input directly into a cell?. For more information, please follow other related articles on the PHP Chinese website!