Lock cells in Excel and set a password animation tutorial

Source: Internet
Author: User

Excel2003 Tutorial 41, locking cells and encrypting in Excel.

Demo Animation

Operation Steps

When multiple people edit the same workbook document, we can encrypt the worksheet in order to prevent modification of the data that is filled by others.

Start Excel, open the appropriate workbook document, and perform the tools → protect → allow users to edit range command to open the Allow users to Edit Ranges dialog box.

Click the New button to open the New Zone dialog box, enter a title in the box under title (such as "build"), then press the red button on the right side of the reference cell to convert the dialog box to a floating bar, select the appropriate area with the mouse, and then press the red button to the right of the floating bar to return to the dialog box. Set the password, press the "OK" button, and then confirm enter the password once, OK return.

Repeat these actions to set the password for the other locale.

When the settings are complete, press the "Protect Sheet" button to encrypt the worksheet.

After this setting, to edit the appropriate area, you must enter the correct password, otherwise you will not be able to enter the edit.

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.