Today we will discuss how to password Excel file. This tool is included with Microsoft Office. Excel allows you to create tables of different complexity, use formulas, as well as individual design. All current versions of the application support password setup.
Instruction
We proceed to a phased description of the process of how to password the Excel file. This feature is provided to files in * .xls format, like any other Microsoft Office documents, including Word and Access. So, after finishing work with the document, press the “File” button, which is located in the menu at the top of the Microsoft Excel window. In the list that appears, we turn to the item “Save As” by clicking on it once with the left mouse button. A window for saving the document will appear, in it we will find the “Service” menu, click the inverted triangle, and then use the appeared function “General parameters”.
Customization
Moving on to the next step in deciding how to password-protect an Excel file. The “General Settings” section appears on the screen. Here you must enter the password to change or open the document. In addition, if you activate the "Read Only" function, when you try to open a password-protected Excel file, toolbar will be disabled by default.
If you set security only to launch the document, a prompt will appear every time you open the table. In this case, all users who will know the secret combination will be able to create arrays and edit data. Regarding the question of how to open a password-protected file Excel if protection is set to change the material, the launch will occur as standard, without any requests. However, if you add new data to the table and try to save the document, the application will ask you to specify a secret combination.
When both types of passwords are set, double entry is required during start-up and closure of the material. It is important to know that you can set different passwords for editing and opening a file.
We return to the setting. When the password (or their pair) is set, click in the "General parameters" button "OK". In the explorer enter the name of the document, save the file using the appropriate function.
Remove protection
Next, we discuss how to disable the password in Excel. To solve the problem, no additional software is needed, since the function is provided by the application’s built-in tools.
Run Excel. Open the document that you need to get rid of password protection. Use the menu "File". Specify "Save As", and then open the "Service" menu. Go to the "General settings", use a double click on the asterisks in the password bar. Use the "Del" key for the desired action. Confirm the operation by pressing the “OK” button. Click "Save", and then "Yes" in a new window.
That's all, the password in the Excel workbook is removed. With the sheet, everything happens in a similar way. Open the “Service” menu, use the “Unprotect” command. To confirm the cancellation action, you will have to enter a previously assigned password. From now on, you know how to password-protect an Excel file, and how to cancel protection if necessary.
