How is the worksheet protected in Excel2007?

Source: Internet
Author: User

Excel2007 worksheet protection is very flexible, through the example below, I believe that friends will appreciate its benefits. Here, you will use the following features of Excel2007:

★ Insert Formula

★ Protect Worksheet

★ Remove Worksheet protection

First Step: Cell protection

By default, all cells have a locked property, and once the EXCEL2007 worksheet is protected, no data can be entered in those cells, so we have to cancel the locking properties of some cells.

First, you right-click the row and column junction of the worksheet, which produces two results: Select all cells and pop-up shortcut menus, and then click Format Cells, as shown in Figure 1.

Figure 1 Preparing cell formatting

Next, click Protect in the pop-up dialog box to switch to the tab page, as shown in Figure 2.

Figure 2 Customizing settings

Then, after you check lock and hide, click OK to exit the setup status and return to the Excel editing interface.

Step Two: Cancel the protection status of some cells

Select the range of the object cells, right-click, and select Format cells, as shown in Figure 3

Figure 3 Setting preparation

Then follow the previous action to clear the hook before the lock and hide, as shown in Figure 4.

Figure 4 Clearing the protection status of a cell

Step Three: Protect your worksheet

First, click Review to switch to the tool panel, then click Protect Sheet, then enter the password two times (the password must be the same two times), and then click OK, as shown in Figure 5.

Figure 5 Entering a password

Fourth step: test protection effect

Entering data in these cells will get the rejection dialog shown in Figure 18. In this way, we can only enter the data in the unprotected cell, which does not affect the normal use of the performance statistics, but also effectively protects the worksheet from being incorrectly manipulated.

Figure 6 Some of the cells are protected.

Fifth step: Unprotect the worksheet

If the EXCEL2007 worksheet is protected, the Protect Sheet button automatically changes to unprotect sheet, and we can click the button and then enter the previous password to unprotect the worksheet, as shown in Figure 7.

Figure 7 Removing worksheet protection

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.