Home > Topics > word > body text

How to implement table locking in excel

醉折花枝作酒筹
Release: 2023-01-13 00:43:56
Original
46576 people have browsed it

Implementation method: First open the excel sheet that needs to be operated, click the "Review"-"Protect Worksheet" option at the top of the page; then enter the set password in the pop-up "Protect Worksheet" dialog box , click "OK" below; enter the password again in the "Confirm" dialog box that finally pops up, and click "OK" below.

How to implement table locking in excel

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the computer, find the Excel table file we want to lock, double-click the file name or right-click the mouse and click Open to enter the table content.

How to implement table locking in excel

Enter the table content, click "Review" in the toolbar above the table, and the function options corresponding to the review tool will appear below the toolbar.

How to implement table locking in excel

In the function options below the review, click "Protect Worksheet", and the Protect Worksheet dialog box will pop up.

How to implement table locking in excel

# Locking the worksheet requires a password to protect it. Enter the password we set in the Protect Worksheet dialog box and click OK below.

How to implement table locking in excel

After clicking OK, the "Confirm Password" dialog box will pop up. Here we need to enter the password we set again. Make sure that the two passwords are consistent. After confirming that they are correct, Click "OK" and the locking of the Excel table is completed.

How to implement table locking in excel

For a locked Excel table, when the worksheet protection is not revoked, when we click anywhere in the table, we will be prompted that the worksheet is protected, so that Don't worry about the contents in the table being modified.

Related learning recommendations: excel tutorial

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template