How Excel Tables Set passwords

Source: Internet
Author: User

① First, click the "Tools" menu on the Excel2003 menu and select "Options" in the pop-up Drop-down list.

② enter security in the Options window that pops up, and then enter the password after "open password";

③ at this point, there will be a "Confirm Password" dialog box, we are here again into the same password to determine.

  Excel2007 Table Set Password

① Click the Office button in the upper-left corner of Excel2007, and then select Encrypt document in prepare.

② Enter the password you want in the "encrypted document" pop-up.

③ agreed to pop up a "Confirm Password" dialog box where we re-enter the password and finalize the setup.

  Set Password in Excel2010 table

① Open the Excel2010, click enter "File";

② on the "File" page, select "Information" on the left, then click "Protect Workbook" on the right, and select "Encrypt with Password" in the dropdown option;

③ Enter the password in the "encrypted Document" that pops up, then click "OK" button;

④ Enter the password again in the "Confirm Password" dialog box that pops up, OK.

  How to cancel Excel passwords

How do I remove these passwords when I set a password for the Excel table? The method is very simple, we simply go to the table file, and then repeat the above steps, in the pop-up "encrypted document" will be entered in the password section blank, and then confirm that the password can be canceled.

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: 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.