excel2010 How to protect the cell

Source: Internet
Author: User

When you use Excel 2010, you want to lock certain cells to prevent others from tampering or accidentally deleting data. So how does this work? Please see below for specific steps:


Open Excel 2010, select any cell, right-click, open menu, select Format Cells command

Switch to the Protection tab, where we can see that the Lock check box is checked by default, which means that once the worksheet is locked, all cells are locked.

Press CTRL + A shortcut to select all cells, right-click Format cell, switch to the Protection tab, tick the small box in front of the lock, and click OK to save the settings

Then select the cells you want to protect, check the Lock checkbox

Switch to the Review tab, click the Protect Sheet button in the change group

The Protect Sheet dialog box pops up, and all users who allow this worksheet can choose which actions are allowed in the list box, and generally leave the default settings

Here we can also set unlock lock when prompted to enter a password, just remove the worksheet protection in the Password text box to type the set of password can be

When you try to edit a cell that is locked, the following prompt dialog box appears

If you want to unlock, switch to the Review tab, and in the Change group, click the Undo Sheet Protection button

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.