How to password a Excel-file, and also to remove protection
Today we will discuss how to secure an 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 the password setting.
We proceed to a step-by-step description of the process,how to password an Excel file. This feature is provided to files in * .xls format, as well as any other Microsoft Office documents, including Word and Access. So, after finishing the work with the document, we press the "File" button, which is located in the menu, at the top of the Microsoft Excel window. In the list that appears, go to the "Save As" item by clicking it once with the left mouse button. There will be a window for saving the document, in it we find the menu "Service", click the inverted triangle, and then use the appeared function "General parameters".
We proceed to the next stage of the solution of the problem ofhow to password an Excel file. The "General settings" section appears on the screen. Here you must enter a password to change or open the document. In addition, if you activate the "Read only" function, when you try to open an Excel file, the toolbar will be disabled by default.
If you set protection only for startupdocument, an input prompt will occur each time the table is opened. In this case, all users who will know the secret combination, will be able to create arrays and edit data. As for the question of how to open an Excel password-protected file, if protection is set to change the material, the launch will occur as standard, without any queries. 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 startup and closing 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 on the "General Settings" button "OK". In the Explorer, enter the name of the document, save the file using the appropriate function.
Next, we discuss how the password is turned off inExcel application. To solve the problem, no additional software is needed, since the function is provided by the built-in tools of the application.
Run Excel. Open the document, which you need to get rid of the password protection. Use the "File" menu. Specify "Save as", and then open the "Tools" menu. Go to the "General Settings", apply a double click on the asterisks in the password line. Use the "Del" key for the desired action. Confirm the operation by clicking 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 "Tools" menu, use the "Unprotect" command. To confirm the cancellation action, you will have to enter the password previously assigned. From now on, you know how to password the Excel file, and also how to unprotect if necessary.