How to lock cells in excel table and not allow editing

How to lock cells in Excel table and do not allow editing: First select all the cells, right-click and set the cell format; then click [Protect], remove the check and lock; then select the area to be locked , and check Lock; finally click [Review-Protect Worksheet] and check all options.

How to lock cells in Excel table and do not allow editing:

1. Select all cells—— Right-click - Format cells

2. In the pop-up window, protect--uncheck the lock--click OK

3. Select the area to be locked - right-click - Format cells

In the pop-up window, protect - check Lock - click OK

4. Top of Excel, review-protect worksheet

5. Pop-up window , select all, click OK. Complete the operation

Related learning recommendations:excel basic tutorial

The above is the detailed content of How to lock cells in excel table and not allow editing. For more information, please follow other related articles on the PHP Chinese website!