Excel2003 Table Set Password
① 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.
How do you set a password for the